Spreadsheet: 866362d1713293076-trying-and-failing-to-create-a-formula-to-count-or-sum-the-number-of-people-scheduled-book2
Sheet: Sheet1

Monclova
House 5085
Requirements |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1
Week 1 | Monday | 00:00:00 | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00
 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  | 1 | 1
 | Tuesday
 | Wednesday
 | Thursday
 | Friday
 | Saturday
 | Sunday
 |  |  |  |  |  |  |  | Week 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 2
# of Sat | # of Sun | # of Days Off | # of Days Off | Orientation Date | Partner Name | Status | Holiday Rotation | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday |  |  | Saturday |  |  | Sunday |  |  | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday |  |  | Saturday |  |  | Sunday |  |  | Week 1 Total | Week 2 Total | Per Pay Period
 |  |  |  |  |  |  |  | From | To |  | From | To |  | From | To |  | From | To |  | From | To |  | From | To |  | From | To |  | From | To |  | From | To |  | From | To |  | From | To |  | From | To |  | From | To |  | From | To
 |  |  |  |  | [NAME] 1 |  |  | 07:00:00 | 15:00:00 |  | 07:00:00 | 15:00:00 |  | 07:00:00 | 15:00:00 |  |  |  |  |  |  |  | 07:00:00 | 15:00:00 |  | 07:00:00 | 15:00:00 |  |  |  |  | 07:00:00 | 15:00:00 |  | 07:00:00 | 15:00:00 |  | 07:00:00 | 15:00:00 |  | 07:00:00 | 15:00:00
 |  |  |  |  | [NAME] 2 |  |  |  |  |  | 07:00:00 | 15:00:00 |  | 07:00:00 | 15:00:00 |  | 07:00:00 | 15:00:00 |  | 07:00:00 | 15:00:00 |  |  |  |  |  |  |  | 07:00:00 | 15:00:00 |  | 07:00:00 | 15:00:00 |  | 07:00:00 | 15:00:00 |  |  |  |  |  |  |  | 07:00:00 | 15:00:00 |  | 07:00:00 | 15:00:00
 |  |  |  |  | [NAME] 3 |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 | 15:00:00 |  | 07:00:00 | 15:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 | 15:00:00 |  |  |  |  | 07:00:00 | 15:00:00 |  | 07:00:00 | 15:00:00
 |  |  |  |  | [NAME] 4 |  |  | 07:00:00 | 15:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 | 15:00:00 |  | 07:00:00 | 15:00:00 |  | 07:00:00 | 15:00:00 |  |  |  |  |  |  |  |  |  |  | 07:00:00 | 15:00:00
 |  |  |  |  | [NAME] 5 |  |  |  |  |  | 15:00:00 | 23:00:00 |  | 15:00:00 | 23:00:00 |  | 15:00:00 | 23:00:00 |  |  |  |  | 15:00:00 | 23:00:00 |  | 15:00:00 | 23:00:00 |  |  |  |  | 15:00:00 | 23:00:00 |  | 15:00:00 | 23:00:00 |  | 15:00:00 | 23:00:00 |  | 15:00:00 | 23:00:00
 |  |  |  |  | [NAME] 6 |  |  |  |  |  | 15:00:00 | 23:00:00 |  | 15:00:00 | 23:00:00 |  | 15:00:00 | 23:00:00 |  | 15:00:00 | 23:00:00 |  |  |  |  |  |  |  | 15:00:00 | 23:00:00 |  | 15:00:00 | 23:00:00 |  | 15:00:00 | 23:00:00 |  |  |  |  |  |  |  | 15:00:00 | 23:00:00 |  | 15:00:00 | 23:00:00
 |  |  |  |  | [NAME] 7 |  |  | 15:00:00 | 23:00:00 |  |  |  |  |  |  |  |  |  |  | 15:00:00 | 23:00:00 |  |  |  |  |  |  |  | 15:00:00 | 23:00:00
 |  |  |  |  | [NAME] 8 |  |  | 15:00:00 | 23:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00 | 23:00:00 |  | 15:00:00 | 23:00:00 |  |  |  |  |  |  |  |  |  |  | 15:00:00 | 23:00:00 |  | 15:00:00 | 23:00:00
 |  |  |  |  | [NAME] 9 |  |  | 23:00:00 | 07:00:00 |  | 23:00:00 | 07:00:00 |  |  |  |  | 23:00:00 | 07:00:00 |  |  |  |  | 23:00:00 | 07:00:00 |  | 23:00:00 | 07:00:00 |  | 23:00:00 | 07:00:00 |  |  |  |  | 23:00:00 | 07:00:00 |  | 23:00:00 | 07:00:00 |  | 23:00:00 | 07:00:00
 |  |  |  |  | [NAME] 10 |  |  |  |  |  |  |  |  | 23:00:00 | 07:00:00 |  |  |  |  | 23:00:00 | 07:00:00 |  |  |  |  |  |  |  |  |  |  | 23:00:00 | 07:00:00 |  |  |  |  |  |  |  |  |  |  | 23:00:00 | 07:00:00 |  | 23:00:00 | 07:00:00