Totaling Hours - won't go past 24:00

[sooz]

Hiya,

I'm trying to add up a column of hours, however I'm finding because I'm using a date format (hh:mm:ss), it won't total past 24 hours.

For example, if I add together 12:30:00 and 12:30:00 I should get 25:00:00, however I get 01:00:00.

Is there some way I can correctly add together a long list of hours? I assume something needs to be added to the sum formula.

I'd appreciate anyone's help.

sooz

 

[Aladin Akyurek]

Custom format the result cell as:

[h]:mm

 

[sooz]

Great, thanks very much!