Creating an employee work schedule that will calculate time worked

I'm fairly new to Excel but I need to create a work schedule for my employees that will also allow me to total the hours they are scheduled for their work week. So far I've created a fake schedule and am using Data Validation to create the shifts but I am stuck on how to give each shift a number value. For ex Shift 6-230p=8 hours. and if possible, let me know if I've scheduled enough people. For example our schedule operates with a minimum of 10 employees each day. I'm hoping there's a formula that will let me know if I've scheduled enough people for each shift for the day. Any help would be greatly appreciated.

I'm attaching the schedule I've made so far to try and give someone an idea of what I'm trying to do

Thanks

Hi,

Please find attached excel file, i have calculate total work hours as per requirements.

Click *Add Reputation to say Thank and Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) If you are satisfied

regards Imran.

Originally Posted by Tlyke212

I'm fairly new to Excel but I need to create a work schedule for my employees that will also allow me to total the hours they are scheduled for their work week. So far I've created a fake schedule and am using Data Validation to create the shifts but I am stuck on how to give each shift a number value. For ex Shift 6-230p=8 hours. and if possible, let me know if I've scheduled enough people. For example our schedule operates with a minimum of 10 employees each day. I'm hoping there's a formula that will let me know if I've scheduled enough people for each shift for the day. Any help would be greatly appreciated.

I'm attaching the schedule I've made so far to try and give someone an idea of what I'm trying to do

Thanks

I have almost the same question. Im unable to open ur link but im rostering 12 staff over 4 weeks. They do 8-6, 8-8 8-9 8pm to 8am, etc. Id like all these entries- their toal hour value to add at end of line.

Hi,

i used vlookup becoz your work schedule shift is daily basis and shift timing is change on day by day, so i am using vlookup.

Click *Add Reputation to say Thank and Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) If you are satisfied

regards Imran.