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

calculate time in days:hours:minutes
 

=(DAYS360(C1,C2)+1)&":"&HOUR(C2-C1)&":"&MINUTE(C2-C1)

"Stice" wrote:

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