Calc with time

M

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.
 
E

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
 
A

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.
 
Top