Shift Schedule

Shift Schedule For the Week of: Department Name:

10/22/2001

Monday Kelly F Tom Y James S Jon M Sean P Teresa A

7:00 AM

8:00 AM

9:00 AM

10:00 AM

11:00 AM

12:00 PM

1:00 PM

2:00 PM

3:00 PM

manager

manager

manager

manager

manager

manager

manager

manager

manager

cashier

cashier

cashier

cashier

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

cashier

cashier

cashier

cashier

Sick

TOTAL 9 4 7 7 0 4

Tuesday Kelly F Tom Y James S Jon M Sean P Teresa A

7:00 AM

8:00 AM

9:00 AM

10:00 AM

11:00 AM

12:00 PM

1:00 PM

2:00 PM

3:00 PM

manager

manager

manager

manager

manager

manager

manager

manager

manager

cashier

cashier

cashier

cashier

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

cashier

cashier

cashier

Sick cashier

TOTAL 9 4 7 7 0 4

Wednesday 7:00 AM

8:00 AM

9:00 AM

10:00 AM

11:00 AM

12:00 PM

1:00 PM

2:00 PM

3:00 PM

manager

manager

manager

manager

manager

manager

manager

manager

manager

Kelly F Tom Y James S Jon M Sean P Teresa A

cashier

cashier

cashier

cashier

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk Sick

cashier

cashier

cashier

cashier

TOTAL 9 4 7 7 0 4

Thursday Kelly F Tom Y James S Jon M Sean P Teresa A

7:00 AM

8:00 AM

9:00 AM

10:00 AM

11:00 AM

12:00 PM

1:00 PM

2:00 PM

3:00 PM

manager

manager

manager

manager

manager

manager

manager

manager

manager

cashier

cashier

cashier

cashier

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

cashier

cashier

cashier

Sick cashier

TOTAL 9 4 7 7 0 4

Friday Kelly F Tom Y James S Jon M Sean P Teresa A

7:00 AM

8:00 AM

9:00 AM

10:00 AM

11:00 AM

12:00 PM

1:00 PM

2:00 PM

3:00 PM

manager

manager

manager

manager

manager

manager

manager

manager

manager

cashier

cashier

cashier

cashier

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk Sick

cashier

cashier

cashier

cashier

TOTAL 9 4 7 7 0 4

Saturday Kelly F Tom Y James S Jon M Sean P Teresa A

7:00 AM

8:00 AM

9:00 AM

10:00 AM

11:00 AM

12:00 PM

1:00 PM

2:00 PM

3:00 PM

manager

manager

manager

manager

manager

manager

manager

manager

manager

cashier

cashier

cashier

cashier

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

cashier

cashier

cashier

Sick cashier

TOTAL 9 4 7 7 0 4

Sunday Kelly F Tom Y James S Jon M Sean P Teresa A

7:00 AM

8:00 AM

9:00 AM

10:00 AM

11:00 AM

12:00 PM

1:00 PM

2:00 PM

3:00 PM

manager

manager

manager

manager

manager

manager

manager

manager

manager

cashier

cashier

cashier

cashier

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

front desk

cashier

cashier

cashier

Sick cashier

TOTAL 9 4 7 7 0 4

You can use this Shift Schedule worksheet to help you schedule and track the hourly assignments for members of your team. You can modify the employee names, working hours, or shift assignments by replacing the sample information with your own. You can also add more employee names or working hours, or change shift assignments. To add more employee names 1. Click in the first cell with an employee name in it for Monday. 2. On the Insert menu, click Row. 3. A new, blank row will be inserted above the first name in the list. Enter the new employee's name above the others. 4. To add the formula that will total the number of hours entered for the new employee, copy and paste from the row below. 5. Repeat as many times as needed for each new employee, and repeat for the groups of cells for Tueday through Saturday. To add more working hours 1. Click in the first cell after the last working hour with a time in it for Monday. 2. On the Insert menu, click Column. 3. A new, blank column will be inserted next to the last one. Enter the time for the new working hour. 4. Repeat as many times as needed for each new working hour. To change shift assignments 1. For each hour that an employee will work, enter the name of the position they will be assigned to in the cell where employee name and hour intersect. 2. The Total column adds up all the hours for an employee where text has been entered in a cell. 3. You can use the last column before the total for notes such as "Sick" or "Overtime." 4. You can also change the background color or pattern to correspond to certain shifts by selecting the cell and then clicking Cells on the Format menu. Then, in the Format Cell dialog box, click the Patterns tab, select a color, and then click OK. These instructions will not be printed out when you print your schedule.

position they will be assigned to in the cell where employee name and hour intersect. 2. The Total column adds up all the hours for an employee where text has been entered in a cell. 3. You can use the last column before the total for notes such as "Sick" or "Overtime." 4. You can also change the background color or pattern to correspond to certain shifts by selecting the cell and then clicking Cells on the Format menu. Then, in the Format Cell dialog box, click the Patterns tab, select a color, and then click OK. These instructions will not be printed out when you print your schedule.