Time Sheet Challenge

[dps9460]

I DESPERATELY need help in calculating the day and night hours for
particular day. Sometimes work hours carry over into the next day an
need to be shown for that day (see FRI). I really need help. Maybe yo
can guide me in the right direction.

Day/Wed Date/9/1 Start/8A End/5P Total da
hours/9.00 Total hours worked/9.00
Day/Thu Date/9/2 Start/5A End/6P Total day hours/12.00
Total night hours/1.00 Total hours worked/13.00
Day/Fri Date/9/3 Start/5A End/6A Tota
day hours/12.00 Total night hours/13.00 Total hours worked/25.0

 

[Sandy Mann]

Hi,

What you're asking is not as simple as it looks especially if you have work
periods straddling day/night night/day and going past midnight. It is
further complicated by the fact that you seem to be using decimal hours
instead of XL times. A Dave WL asked a similar question on 30 Dec 2003,
here is a shortcut to the thread:

http://tinyurl.com/5cgfs

I would also suggest that you read the following web sites, (the order is
not significant)

www.cpearson.com/excel/datetime.htm

http://www.cpearson.com/excel/DateTimeWS.htm

http://www.cpearson.com/excel/overtime.htm

http://j-walk.com/ss/excel/files/timesht.htm

http://www.j-walk.com/ss/excel/files/index.htm

http://www.mvps.org/dmcritchie/excel/datetime.htm


HTH

Sandy