# Windows

## General discussion

Locked

### Excel & Time Calculations

By ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

Collapse -

### Excel & Time Calculations

by In reply to Excel & Time Calculations

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.

Collapse -

### Excel & Time Calculations

by In reply to Excel & Time Calculations

sorry this is the formula:

=B1-A1=(IF(A1>B1,1))

Collapse -

### Excel & Time Calculations

by In reply to Excel & Time Calculations

argh. Sorry again. My caffiene levels are too low

=B1-A1+(IF(A1>B1,1))

Collapse -

### Excel & Time Calculations

by In reply to Excel & Time Calculations

Collapse -

### Excel & Time Calculations

by In reply to Excel & Time Calculations

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

Collapse -

### Excel & Time Calculations

by In reply to Excel & Time Calculations

Collapse -

### Excel & Time Calculations

by In reply to Excel & Time Calculations

This can be expanded to include dates for the Monday-Tuesday situation.

Collapse -

### Excel & Time Calculations

by In reply to Excel & Time Calculations

Collapse -

### Excel & Time Calculations

by In reply to Excel & Time Calculations

This question was closed by the author

• 48

• 25

• 18

• 4