Spreadsheet: 788069d1658247245-creating-a-schedule-but-i-need-the-formula-to-check-to-see-if-that-shift-is-filled-schedule-assisant
Sheet: Sheet1

Schedule
Shift # | Filled | Employee Name | SUN | SUN | MON | MON | TUES | TUES | WED | WED | THUR | THUR | FRI | FRI | SAT | SAT | Total End | Total Start | Total Hours
1 | Filled | Dray | OFF | OFF | 4:00a | 12:30p | 4:00a | 12:30p | 4:00a | 12:30p | 4:00a | 12:30p | 4:00a | 12:30p | OFF | OFF
2 | Filled | Fritz | OFF | OFF | OFF | OFF | 4:00a | 12:30p | 4:00a | 12:30p | 4:00a | 12:30p | 4:00a | 12:30p | 4:00a | 12:30p
3 | Filled | [NAME] | 4:00a | 12:30p | 4:00a | 12:30p | 4:00a | 12:30p | 4:00a | 12:30p | OFF | OFF | 4:00a | 12:30p | OFF | OFF
4 | Filled | Isidro Roman | 8:00a | 12:00p | OFF | OFF | 7:00a | 5:00p | 7:00a | 5:00p | 7:00a | 5:00p | 7:00a | 5:00p | OFF | OFF
5 | Filled | [NAME] | 4:00a | 12:30p | 4:00a | 12:30p | OFF | OFF | OFF | OFF | 4:00a | 12:30p | 4:00a | 12:30p | 4:00a | 12:30p
6 | Filled | [NAME] | 5:00a | 2:00p | OFF | OFF | 5:00a | 2:00p | 5:00a | 2:00p | 5:00a | 2:00p | 5:00a | 2:00p | OFF | OFF
7 | Filled | Martinez | 3:30a | 3:30p | 3:30a | 8:30a | 3:30a | 8:30a | 3:30a | 8:30a | 3:30a | 8:30a | OFF | OFF | OFF | OFF
8 | Filled | [NAME]? | 5:00a | 1:30p | 5:00a | 1:30p | OFF | OFF | OFF | OFF | 5:00a | 1:30p | 5:00a | 1:30p | 5:00a | 1:30p
9 | Filled | [NAME] | 6:00a | 2:30p | 6:00a | 2:30p | OFF | OFF | OFF | OFF | 6:00a | 2:30p | 6:00a | 2:30p | 6:00a | 2:30p
10 | Filled | [NAME] | 6:00a | 2:30p | 6:00a | 2:30p | OFF | OFF | OFF | OFF | 6:00a | 2:30p | 6:00a | 2:30p | 6:00a | 2:30p
11 | Filled | Rodcliff | 6:00a | 2:30p | OFF | OFF | OFF | OFF | 6:00a | 2:30p | 6:00a | 2:30p | 6:00a | 2:30p | 6:00a | 2:30p
12 | Filled | Romario (IN SCHOOL) | OFF | OFF | 7:00a | 12:00p | 7:00a | 12:00p | 1:00p | 5:00pm | OFF | OFF | 7:00a | 5:00p | OFF | OFF
13 | Filled | [NAME] | 8:00a | 4:30p | 8:00a | 4:30p | 8:00a | 4:30p | 8:00a | 4:30p | OFF | OFF | 8:00a | 4:30p | OFF | OFF
14 | Filled | [NAME] | 8:00a | 4:30p | 8:00a | 4:30p | 8:00a | 4:30p | 8:00a | 4:30p | 8:00a | 4:30p | OFF | OFF | OFF | OFF
15 | Filled | [NAME] | 8:00a | 4:30p | 8:00a | 4:30p | 8:00a | 4:30p | 8:00a | 4:30p | 8:00a | 4:30p | OFF | OFF | OFF | OFF
16 |  |  | OFF | OFF | 10:00a | 6:30p | 10:00a | 6:30p | OFF | OFF | 10:00a | 6:30p | 10:00a | 6:30p | 5:00a | 1:30p
17 |  |  | OFF | OFF | OFF | OFF | 9:00a | 5:30p | 9:00a | 5:30p | 9:00a | 5:30p | 9:00a | 5:30p | 9:00a | 5:30p
18 |  |  | 10:00a | 6:30p | OFF | OFF | OFF | OFF | 10:00a | 6:30p | 10:00a | 6:30p | 10:00a | 6:30p | 10:00a | 6:30p
19 | Filled | Ayman | OFF | OFF | OFF | OFF | 9:00a | 5:30p | 9:00a | 5:30p | 9:00a | 5:30p | 9:00a | 5:30p | 9:00a | 5:30p
20 | Filled | Eddie? | 10:00a | 6:30p | 10:00a | 6:30p | 10:00a | 6:30p | OFF | OFF | OFF | OFF | 10:00a | 6:30p | 10:00a | 6:30p
21 | Filled | Kujo/Sean | 10:00a | 6:30p | OFF | OFF | OFF | OFF | 10:00a | 6:30p | 10:00a | 6:30p | 10:00a | 6:30p | 10:00a | 6:30p
22 | Filled | Tarquinn | 10:00a | 6:30p | 10:00a | 6:30p | 10:00a | 6:30p | 10:00a | 6:30p | 10:00a | 6:30p | OFF | OFF | OFF | OFF
23 | Filled | Kymani | 12:00p | 8:30p | 12:00p | 8:30p | 12:00p | 8:30p | OFF | OFF | OFF | OFF | 12:00p | 8:30p | 12:00p | 8:30p
24 |  |  | 11:00a | 7:30p | OFF | OFF | OFF | OFF | 11:00a | 7:30p | 11:00a | 7:30p | 11:00a | 7:30p | 11:00a | 7:30p
26 | Filled | Jauchswa | 1:00p | 9:30p | 1:00p | 9:30p | 1:00p | 9:30p | OFF | OFF | OFF | OFF | 1:00p | 9:30p | 1:00p | 9:30p
26 | Filled | Alicia | OFF | OFF | 5:30p | Close | 5:30p | Close | 5:30p | Close | 5:30p | Close | 5:30p | Close | OFF | OFF
27 | Filled | Schiller Verneus | 3:00p | 11:30p | 3:00p | 11:30p | 3:00p | 11:30p | OFF | OFF | 3:00p | 11:30p | 3:00p | 11:30p | OFF | OFF
28 | Filled | Caleto | 3:00p | 11:30p | 3:00p | 11:30p | 1:00p | 9:30p | 1:00p | 9:30p | 3:00p | 11:30p | OFF | OFF | OFF | OFF
29 | Filled | Phyl Underwood | OFF | OFF | OFF | OFF | OFF | OFF | 4:00p | 12:30a | 4:00p | 12:30a | 4:00p | 12:30a | OFF | OFF
30 |  |  | 4:00p | Close | 4:00p | Close | OFF | OFF | OFF | OFF | 4:00p | Close | 4:00p | Close | 4:00p | Close
31 | Filled | [NAME] | 4:00p | Close | 4:00p | Close | OFF | OFF | 4:00p | Close | 4:00p | Close | 4:00p | Close | OFF | OFF
Scheduled by Hour
 |  |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  | 12:00a
 |  | 1:00a
 |  | 2:00a
 |  | 3:00a
 |  | 3:30a
 |  | 4:00a
 |  | 4:30a
 |  | 5:00a
 |  | 5:30a
 |  | 6:00a
 |  | 6:30a
 |  | 7:00a
 |  | 7:30a
 |  | 8:00a
 |  | 8:30a
 |  | 9:00a
 |  | 9:30a
 |  | 10:00a
 |  | 10:30a
 |  | 11:00a
 |  | 11:30a
 |  | 12:00p
 |  | 12:30p
 |  | 1:00p
 |  | 1:30p
 |  | 2:00p
 |  | 2:30p
 |  | 3:00p
 |  | 3:30p
 |  | 4:00p
 |  | 4:30p
 |  | 5:00p
 |  | 5:30p
 |  | 6:00p
 |  | 6:30p
 |  | 7:00p
 |  | 7:30p
 |  | 8:00p
 |  | 8:30p
 |  | 9:00p
 |  | 9:30p
 |  | 10:00p
 |  | 10:30p
 |  | 11:00p
 |  | 11:30p
Model by Hour
 |  |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
Hour 0 |  | 12:00am - 12:59am | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1
Hour 1 |  | 1:00am - 1:59am | 1 |  | 1 |  | 0 |  | 1 |  | 1 |  | 1 |  | 0
Hour 2 |  | 2:00am - 2:59am | 1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 1
Hour 3 |  | 3:00am - 3:59am | 3 |  | 3 |  | 1 |  | 1 |  | 3 |  | 3 |  | 1
Hour 4 |  | 4:00am - 4:59am | 16 |  | 12 |  | 6 |  | 9 |  | 9 |  | 15 |  | 7
Hour 5 |  | 5:00am - 5:59am | 9 |  | 7 |  | 3 |  | 4 |  | 4 |  | 8 |  | 3
Hour 6 |  | 6:00am - 6:59am | 8 |  | 6 |  | 5 |  | 5 |  | 7 |  | 11 |  | 7
Hour 7 |  | 7:00am - 7:59am | 5 |  | 7 |  | 4 |  | 4 |  | 6 |  | 9 |  | 5
Hour 8 |  | 8:00am - 8:59am | 7 |  | 10 |  | 6 |  | 5 |  | 7 |  | 9 |  | 5
Hour 9 |  | [NAME] | 9 |  | 8 |  | 7 |  | 7 |  | 7 |  | 10 |  | 6
Hour 10 |  | 10:00am - 10:59am | 16 |  | 9 |  | 10 |  | 10 |  | 11 |  | 13 |  | 9
Hour 11 |  | 11:00am - 11:59am | 16 |  | 13 |  | 9 |  | 9 |  | 11 |  | 16 |  | 6
Hour 12 |  | 12:00pm - 12:59pm | 14 |  | 11 |  | 9 |  | 10 |  | 10 |  | 12 |  | 10
Hour 13 |  | 1:00pm - 1:59pm | 10 |  | 10 |  | 10 |  | 8 |  | 13 |  | 16 |  | 8
Hour 14 |  | 2:00pm - 2:59pm | 13 |  | 16 |  | 12 |  | 11 |  | 18 |  | 17 |  | 8
Hour 15 |  | 3:00pm - 3:59pm | 17 |  | 12 |  | 11 |  | 14 |  | 17 |  | 14 |  | 7
Hour 16 |  | 4:00pm - 4:59pm | 16 |  | 11 |  | 8 |  | 12 |  | 15 |  | 11 |  | 5
Hour 17 |  | 5:00pm - 5:59pm | 14 |  | 9 |  | 5 |  | 6 |  | 10 |  | 7 |  | 4
Hour 18 |  | 6:00pm - 6:59pm | 6 |  | 4 |  | 3 |  | 4 |  | 5 |  | 3 |  | 2
Hour 19 |  | 7:00pm - 7:59pm | 3 |  | 2 |  | 2 |  | 2 |  | 4 |  | 2 |  | 3
Hour 20 |  | 8:00pm - 8:59pm | 4 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2
Hour 21 |  | 9:00pm - 9:59pm | 2 |  | 1 |  | 1 |  | 1 |  | 2 |  | 2 |  | 2
Hour 22 |  | 10:00pm - 10:59pm | 1 |  | 2 |  | 1 |  | 1 |  | 1 |  | 1 |  | 2
Hour 23 |  | 11:00pm - 11:59pm | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 2
Difference Between Schedule & Model
 |  |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
Hour 0 |  | 12:00am - 12:59am
Hour 1 |  | 1:00am - 1:59am
Hour 2 |  | 2:00am - 2:59am
Hour 3 |  | 3:00am - 3:59am
Hour 4 |  | 4:00am - 4:59am
Hour 5 |  | 5:00am - 5:59am
Hour 6 |  | 6:00am - 6:59am
Hour 7 |  | 7:00am - 7:59am
Hour 8 |  | 8:00am - 8:59am
Hour 9 |  | [NAME]
Hour 10 |  | 10:00am - 10:59am
Hour 11 |  | 11:00am - 11:59am
Hour 12 |  | 12:00pm - 12:59pm
Hour 13 |  | 1:00pm - 1:59pm
Hour 14 |  | 2:00pm - 2:59pm
Hour 15 |  | 3:00pm - 3:59pm
Hour 16 |  | 4:00pm - 4:59pm
Hour 17 |  | 5:00pm - 5:59pm
Hour 18 |  | 6:00pm - 6:59pm
Hour 19 |  | 7:00pm - 7:59pm
Hour 20 |  | 8:00pm - 8:59pm
Hour 21 |  | 9:00pm - 9:59pm
Hour 22 |  | 10:00pm - 10:59pm
Hour 23 |  | 11:00pm - 11:59pm