Hi
I am trying to enter a formula that will calculate, in hours, minutes and seconds, that will give me the duration between 2 incidents.
Example:
Start time 22:00:00 and End time of 04:30:30
The time difference between the incidents is 06:30:30 but I cannot get it to display correctly.
I then need to add up all the duration's between incidents and reformat to minutes only (which i have done by *1440) on another document
Can anyone please help with time calculation.
P.s I really dont want to reformat everything to incorporate dates too, just want it to recognize calculated duration's beyond the 24hr period
Thanks
Mark
Bookmarks