Solved Calculating overnight hours in Excel 2013

July 15, 2013 at 08:03:19
Specs: Windows 8
I am trying to create a spreadsheet for employees that work overnight shifts. I have my formulas for when they work, but it adds hours when they are absent. The different shifts are as follows:
Sun thru Thur 4pm-12am=8 hours
Fri 3pm-11pm=8 hours
Sat 4am-12am=20 hours
Sun 4am-4pm=12 hours

Can someone please help?
Janet


See More: Calculating overnight hours in Excel 2013

Report •

#1
July 15, 2013 at 13:18:00
✔ Best Answer
Look here:

http://www.cpearson.com/excel/overt...

Should give you a pretty good start.
Any questions, come back and we'll see if we can help.

MIKE

http://www.skeptic.com/


Report •

#2
July 15, 2013 at 13:24:47
Thanks, Mike.

I will check it out and see if it can help.


Report •
Related Solutions


Ask Question