Calculating the difference between two times

  • Thread starter Michael McDonough
  • 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.
 
P

Peo Sjoblom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hours difference 3
how can we calculate the numbers of hours between two dates and 4
Calculate the difference betwen two columns -two dates 3
Difference of time 3
Sumproduct with date and time? 1
Difference Between Two Times 4
Q: Time Difference 2
Difference between time in excel reported incorrectly 6

Top