Cumulative time

[Scott]

Hi,

I need to input times in hh:mm:ss, much like a stop watch. So, 2 days 12
hours 43 minutes 12 seconds would be 60:43:12 (48 hours plus 12 hours). I
further need to calculate cumulative time (@sum(A1:A999), expressed in
hh:mm:ss).

The default time formats don't seem to work. 25:43:21 in hh:mm:ss displays
as 01:43:21.

I've played with Text, Convert, Int, etc., but can't seemed to get this to
work (IOW I've looked at the online help).

How can I accomplish the above?

Thanks,
Scott

 

[J.E. McGimpsey]

Format your cells with

Format/Cells/Number/Custom [hh]:mm:ss

the brackets tell XL not to roll over time every 24 hours.