View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stice Stice is offline
external usenet poster
 
Posts: 1
Default calculate time in days:hours:minutes

I am trying to get Excel to calculate an elapsed time in simple terms, i.e.
dd:hh:mm. For example: the total elapsed time between 01/01/07 at 0200
(start time) and 02/05/07 at 1530 (stop time)

I would like it to display as 35:13:30 (dd:hh:mm)

I can't seem to get Excel to count past 31 days...it calcualtes correctly up
to the 31 day and then starts over. In the above example, my formula
calculates it as 4:13:30
--
.....Stice