calculated time AM to AM?

Microsoft Office excel 2007 - upgrade
January 26, 2011 at 06:42:13
Specs: Windows XP
I need to be able to calculate my workers times if they work from AM to AM or PM to PM? Can this be done?

See More: calculated time AM to AM?

January 26, 2011 at 11:40:26
Can this be done?



Report •

January 27, 2011 at 05:33:17
So how do I accomplish this. If I want to calculate lets say from 4:00am to 2am or if i need to calculate from one day to another like from 5pm to 6am.

Report •

January 27, 2011 at 09:01:35
A simple way could be something like:

      A               B
1) Time In      1/27/11  8:00
2) Time Out     1/27/11 12:00
3) Time In      1/27/11 12:30
4) Time Out     1/28/11  1:45
6) Lunch 	    0:30
7) Total Hours	   17.25

Column B Cells 1 - 4 are formatted as DATE & TIME
Cell B6 and B7 are Custom format [H]:MM, the square brackets are required.

The formula in Cell B6 is: =SUM(B3-B2)
The formula in Cell B7 is: =SUM(B4-B3)+(B2-B1)

As you can see from my example, crossing over MIDNIGHT can be done.
The format in cells B6 & B7 are the key to getting the correct number of hours.

Doing Date & Time math in Excel can be very tricky.
If you plan on doing Date & Time math then I would advise you to read the below link for a complete explanation of how Excel deals with Dates and Time, it is a great resource.


Report •

Related Solutions

January 27, 2011 at 10:36:06
thanks alot!

Report •

Ask Question