AnsweredAssumed Answered

Elapsed time calculation excluding date

Question asked by MedicInMe on Feb 18, 2013
Latest reply on Feb 22, 2013 by philmodjunk

Title

Elapsed time calculation excluding date

Post

     Hello

      

I am looking to calculate elapsed time in military format that lapses only one day. For example I send out a technician at 23:00 and they work until 02:10. This would be 3 hours and 10 minutes. 

Due to the setup and client's wants the date on the form is for when the call starts. I have set up an excel sheet that performs the function quiet well however the I can't use the same calculation. 

The excel calculation is =--TEXT(MOD(TEXT(B19,"0\:00")-TEXT(B11,"0\:00"),1),"hhmm").

     I do not want to use timestamps as times will not always be entered as things are happening. I have found some calculations that work to calculate the time elapse however the formatting is comes back as 3.1666666666667 instead of 3:10 (3 hours and 10 minutes). 

      

     Any help would be greatly appreciated.

      

     Thanks

     Brian

Outcomes