locked
SharePoint list Date and Time calculator RRS feed

  • Question

  • Hi,

        I have two different colums, one for Date and one of time, for date i choose the default date and time feild, while for time i am using single line text, as i need to input the details per minuts (while default date and time allow 5 minuts interval only)

    I can calculate the single line text feild by below formula (i am putting the time in this format 01:23, 12:29, 17:02, 00:41 ect...)

    =TEXT(MOD(End-Start,1),"hh "" hrs, "" mm "" mins""")

    where cloum "End" end time and "Start" is start time,

    Now how can i calculate total time difference, for Example =((End date - start date)+(end time - start time))

                                                                                               

    Saturday, July 14, 2012 1:14 PM