Getting Wrong Time Total

  • Thread starter Thread starter jon-simek
  • Start date Start date
J

jon-simek

In A1 I put 11:00 in a time format.
In A2 I put 05:00 in a time format.
I try =A1+A2 and get 16:00 for the answer.
But the right answer is 18:00.
Appericate any help.
 
But the right answer is 18:00

How so ? If you move on 5 hours from 11:00 a.m., what time is it in your
universe ?

Seems like here that would be 16:00 which is 4:00 p.m.

Regards

Trevor
 
Hi,

If you're trying to find elapse time between A1 and A2:

=MOD(A2-A1,1)
or
=A2-A1+(A2<A1)

Works even if you cross midnight (as in your example)

Regards,

Daniel M.
 
Back
Top