Calculating the difference between two times

  • Thread starter Thread starter Michael McDonough
  • Start date Start date
M

Michael McDonough

I need to calculate the difference between two times. I
do not have a problem when going from 12:00am to 11:59am.
I also figured out how to calculate the differnce between
12:00am to 11:59pm. How do you calculate the difference
between two times when it goes over two days. For
instance from 10:00am (10/03) to 1:00am (10/04). That is
15 hours, but I cannot get that answer. Also, the dates
are not important, I just need to be able to calculate
that as 15:00 hours.
 
With the start time in A1 (10:00 AM) and the end time in
A2 (01:00 AM) use

=MOD(A2-A1,1)

Regards,

Peo Sjoblom
 
Back
Top