# 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?

#1
January 26, 2011 at 11:40:26
 Can this be done?Yes.MIKEhttp://www.skeptic.com/

Report •

#2
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 •

#3
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 5) 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.http://www.cpearson.com/excel/datet... MIKEhttp://www.skeptic.com/

Report •

Related Solutions

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

Report •