Calc with time

[Maria Soto]

I need sum cells with time. I have this case:

A1=15:17 and A2=23:04
When I sum A1+A2 the result is incorrect:
=Sum(A1:A2) = 14:21 Why????
Thank you.

 

[Peo Sjoblom]

Use custom format

[hh]:mm

returns 38:21

 

[Earl Kiosterud]

Maria,

But it is correct. It's just the next day, which doesn't show with the time
formatting you're using. If you want the hours not to roll to the next day,
(38:21), format it (Format - Cells - Number - Custom) as

[h]:mm
[hh]:mm

 

[Biff]

See replies in .Newusers and .Misc

 

[Andi]

Try applying a custom format to the cell containing the
formula. The custom format should be [h]:mm which will
allow the cell to reflect cumulative time rather than a
24 hour clock.