Calc with time

  • Thread starter Thread starter Maria Soto
  • Start date Start date
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.
 
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
 
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.
 
Back
Top