I am creating a weekly work schedule and want to add hours scheduled for the week. I am able to calculate the hours but having trouble ignorning the days that an employee does not work.
Here's my example of an emplyee that was not scheduled for Sat.
Can someone pls help me with this?
G3 = 11:00 AM
G4 = 3:00 PM
H3 = Blank
H4 = Blank
I3 = 5:00 PM
I4 = 8:00 PM
J3 = total hours for week - difference of G4 and G3 plus difference of I3 and I4
Last edited by robinrobin; 08-14-2010 at 09:10 PM.
This is a basic timekeeping sheet using your layout.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you.
Since there are multiple employees (going down the sprdsht), I was hoping to calculate the total in a cell in column J for each employee. So for example J3 would contain the formula that adds the scheduled hours for an employee and ignores the days the employee is not scheduled.
Here are a couple more basic designs, the first one I think is what you were after.
This is exactly what I was looking for.
Thank you!
RR
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks