employee work schedule

**rdvarona** · 10-22-2009, 10:44 PM

I have an employee work schedule already generated. I need to set up the tabs on the bottom for every day of the week. I also have different shift listed from A to G. Example: A is Mon-Fri 6AM to 2:30 PM, B is Mon-Fri 8AM to 4:30PM, C is Tue-Sat 9AM to 5:30PM. I need a spread sheet that I can plug in the employees name and the shift they work in. Then also set up the days on the week on the tabs below. If i were to click on the Mondays tab it will show me whos working on that day. I need to also include a lunch time for each work group. Lunch is to be taken between the 4th hour and the 6th. Last but not least have 1 column to indicate of the employee is on vacation or called in sick. If the box is checked off it would shade in the employee name a different color. not sure if any one has something like this already set up. I have been trying dofferent ways to set this up but can not figure it out. Please help...

**DonkeyOte** · 10-23-2009, 02:34 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

**rdvarona** · 01-30-2010, 04:30 PM

Here is a sample of my work schedule. Sorry it took so long. I have been working long hours 6 to 7 days a week.

**rdvarona** · 03-14-2010, 11:30 AM

I have an employee work schedule already generated. I need to set up the tabs on the bottom for every day of the week. I also have different shift listed from A to G. Example: A is Mon-Fri 6AM to 2:30 PM, B is Mon-Fri 8AM to 4:30PM, C is Tue-Sat 9AM to 5:30PM. I need a spread sheet that I can plug in the employees name and the shift they work in. Then also set up the days on the week on the tabs below. If i were to click on the Mondays tab it will show me whos working on that day. I need to also include a lunch time for each work group. Lunch is to be taken between the 4th hour and the 6th. Last but not least have 1 column to indicate of the employee is on vacation or called in sick. If the box is checked off it would shade in the employee name a different color. not sure if any one has something like this already set up. I have been trying dofferent ways to set this up but can not figure it out. Please help...