Spreadsheet: 220257d1363109027-not-sure-what-formula-to-use-to-set-up-work-schedule-sample-schedule
Sheet: Sheet1

January
2200-0800 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T
Supervisor 1 |  |  | X | X | X | V | V | V | V | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X
Asst Supervisor 1 | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X
2000-0600 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T
Employee 1 | V | V | V | V | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X
Employee 2 |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X
Employee 3 |  |  | X | X | X |  |  |  |  | X | X | X | V | V | V | V | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X
Employee 4 |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X
Employee 5 | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X
Employee 6 | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X
Employee 7 | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X
Employee 8 |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X
0800-1600 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T
Supervisor 2 |  |  |  |  | X | X |  |  |  |  |  | X | X |  |  |  |  |  | X | X |  |  |  |  |  | X | X
Asst Supervisor 2 | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X
0600-1600 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T
Employee 9 |  |  |  |  | X | X | X | V | V | V | V | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X
Employee 10 |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X
Employee 11 |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X
Employee 12 |  | X | X | X |  |  |  |  | X | X | X | V | V | V | V | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X
Employee 13 | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X
Employee 14 | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X
Employee 15 | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X
1000-2000 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T
Employee 16 |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X | V | V | V | V
Employee 17 | V | V | V | V | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X
Employee 18 | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X
1200-2200 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T
Employee 19 |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X
Employee 20 |  |  |  |  | X | X | X | V | V | V | V | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X
Employee 21 | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X
1600-0200 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T
Supervisor 3 | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X
[NAME] 3 |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X
Employee 22 |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X
Employee 23 | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X
Employee 24 | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X
Employee 25 |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X | V | V | V | V | X | X | X |  |  |  |  | X | X
Employee 26 |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X