Windows Forum

Ask something
Discussion Locked

Excel & Time Calculations

0 helpful
9 replies

by raned

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Using Excel 97 how can I calculate time?
I'm using the following cells:

Start Time cell:
End Time cell:
Total time:

Example1: I Start at 10:00am and End at 2:00pm. How do I calculate an answer of 4:00 hrs in the Total cell?

Example2: What if I span a day? I Start at 8:00pm Monday and End at 1:00am Tuesday. How do I calculate an answer of 5:00 hrs?

Thank you.

9 replies

by launenhaft

Hope this helps:

A1: Start Time B1: End Time

Use this formula in C1
=B1-A1+(IF(A2>B2,1))

Make sure you have the cells formatted for time.

by sheryl v

Does it have to be in Excel? Access 97 has a builtin function called DateDiff, which will calculate the difference between 2 times at whatever you desire (minutes, seconds, hours, etc.)

Otherwise this formula will give you the number of minutes:
=(B1-A1)*1440
1440 = 24 hours a day * 60 minutes per hour

Finaly this formula will give you the number of HOURS:
=(B2-A2)*24

Hope this helped

This discussion is closed to new replies.