General discussion

Locked

Excel & Time Calculations

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

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel & Time Calculations

by launenhaft 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 launenhaft In reply to Excel & Time Calculations

sorry this is the formula:

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

Collapse -

Excel & Time Calculations

by launenhaft 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 raned In reply to Excel & Time Calculations

Poster rated this answer

Collapse -

Excel & Time Calculations

by Sheryl V 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 raned In reply to Excel & Time Calculations

Poster rated this answer

Collapse -

Excel & Time Calculations

by pVp In reply to Excel & Time Calculations

See my answer to this at: http://www.techrepublic.com/forumqa/thread_detail.jhtml?src=search&thread_id=19162

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

Collapse -

Excel & Time Calculations

by raned In reply to Excel & Time Calculations

Poster rated this answer

Collapse -

Excel & Time Calculations

by raned In reply to Excel & Time Calculations

This question was closed by the author

Back to Windows Forum
9 total posts (Page 1 of 1)  

Related Discussions

Related Forums