Excel Scheduling Tool Help Total Scheduled Hours

Hello,

I need a forumla that will total up the total hours scheuled. On some days my employees work split shifts, so I do not know if it would be possible to consider that too. Please see my attachment.

I am not sure what you mean. This will be a schedule of 30+ employees so if I could keep it as simple as possible it would be nice. But whatever we need to do to make it work.

Thank you very much!

I did a little more editing & need a few more tweaks to be where I want to be.

#1) When someone has a vacation or personal day I would like to be able to type VAC or PER and have it count 8 hours towards their total hours worked. Right now I just enter off in one column and put fake hours in the split column.

#2) I need a certain number of openers & a certain number of closers. At the bottom I manually inputed this myself. Is there a way I can make it auto sum this for me? A closer being defined as someone who works until 8PM, an opener someone who starts work at 8:45AM and a mid shift being someone who works but does not meed either criteria.

#3) Last, but not least. Employees get an hour lunch everyday except Sunday they get no lunch. In their total hours how could I make excel automatically recognize this and calculate their hours appropriately?


THANKS IN ADVANCE! PLEASE SEE MY NEW ATTACHMENT.

bump*******************

bump times two

anyone???????

sweet thanks for the help everyone!