Spreadsheet: 472147d1469464859-restaurant-schedule-using-sumproduct-and-countif-formula-almost-done-so-please-advise-gj-schedule-rev-1
Sheet: Colton Shift Schedule

 |  | Grand Junction Shift Schedule
 |  | Aug 15 - Aug 21
 |  | Name | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21 |  | HOURS
 |  |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
 |  | MANAGERS
 |  | [NAME] | 10:00:00 | 20:00:00 | 10:00:00 | 20:00:00 | 10:00:00 | 20:00:00 | 10:00:00 | 20:00:00 | 10:00:00 | 20:00:00
 |  |  | [NAME] |  | [NAME] |  | Cashier |  | Cashier |  | [NAME]
 |  | Jared Shoults | 12:00:00 | 22:00:00 | 12:00:00 | 22:00:00 | 12:00:00 | 22:00:00 |  |  |  |  | 12:00:00 | 22:00:00 | 12:00:00 | 22:00:00
 |  |  | Maintanence |  | Maintanence |  | Maintanence |  |  |  |  |  | Cashier |  | Cashier
 |  | FULL-TIME
 |  | [NAME] | 11:00:00 | 20:00:00 | 11:00:00 | 20:00:00 | 11:00:00 | 20:00:00 | 11:00:00 | 20:00:00 | 11:00:00 | 20:00:00
 |  |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME]
 |  | [NAME] |  |  |  |  | 10:00:00 | 19:00:00 | 10:00:00 | 19:00:00 | 10:00:00 | 19:00:00 | 10:00:00 | 19:00:00 | 10:00:00 | 19:00:00
 |  |  |  |  |  |  | Prep |  | Prep |  | Prep |  | [NAME] |  | [NAME]
 |  | [NAME] | 12:00:00 | 21:00:00 | 12:00:00 | 21:00:00 | 12:00:00 | 21:00:00 | 12:00:00 | 21:00:00 | 12:00:00 | 21:00:00
 |  |  | Cashier |  | Cashier |  | Cashier |  | Cashier |  | Cashier
 |  | [NAME] | 11:00:00 | 20:00:00 |  |  |  |  | 11:00:00 | 20:00:00 | 11:00:00 | 20:00:00 | 13:00:00 | 22:00:00 | 13:00:00 | 22:00:00
 |  |  | [NAME] |  |  |  |  |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME]
 |  | [NAME] | 10:00:00 | 19:00:00 | 10:00:00 | 19:00:00 | 11:00:00 | 20:00:00 |  |  |  |  | 10:00:00 | 19:00:00 | 10:00:00 | 19:00:00
 |  |  | [NAME] |  | [NAME] |  | [NAME] |  |  |  |  |  | Prep |  | Prep
 |  | [NAME] | 10:00:00 | 19:00:00 | 11:00:00 | 20:00:00 |  |  |  |  | 10:00:00 | 19:00:00 | 11:00:00 | 20:00:00 | 11:00:00 | 20:00:00
 |  |  | Cashier |  | Cashier |  |  |  |  |  | Cashier |  | Cashier |  | Cashier
 |  | [NAME] |  |  | 11:00:00 | 20:00:00 | 11:00:00 | 20:00:00 | 11:00:00 | 20:00:00 |  |  | 11:00:00 | 20:00:00 | 11:00:00 | 20:00:00
 |  |  |  |  | Prep |  | Prep |  | Prep |  |  |  | [NAME] |  | [NAME]
 |  | PART-TIME
 |  | Mon - Fri Days
 |  | [NAME] | 11:00:00 | 15:30:00 | 11:00:00 | 15:30:00 | 10:00:00 | 15:30:00 | 10:00:00 | 15:30:00 |  |  | 11:00:00 | 20:00:00
 |  |  | Prep |  | [NAME] |  | [NAME] |  | [NAME] |  |  |  | [NAME]
 |  | [NAME] | 11:00:00 | 15:30:00 | 10:00:00 | 15:30:00 |  |  |  |  | 11:00:00 | 15:30:00 | 11:00:00 | 15:30:00 | 11:00:00 | 15:30:00
 |  |  | Maintanence |  | Maintanence |  |  |  |  |  | Maintanence |  | Maintanence |  | Maintanence
 |  | Mon - Fri Evenings
 |  | Danielle German | 15:30:00 | 21:00:00 | 15:30:00 | 22:00:00 |  |  |  |  |  |  | 10:00:00 | 15:30:00 | 10:00:00 | 15:30:00
 |  |  | Prep |  | [NAME] |  |  |  |  |  |  |  | Prep |  | Prep
 |  | [NAME] |  |  |  |  |  |  | 15:30:00 | 22:00:00 | 15:30:00 | 22:00:00 | 15:30:00 | 21:00:00 | 15:30:00 | 21:00:00
 |  |  |  |  |  |  |  |  | [NAME] |  | Prep |  | Prep |  | Prep
 |  | [NAME] | 15:30:00 | 22:00:00 | 15:30:00 | 21:00:00 | 15:30:00 | 22:00:00 | 15:30:00 | 22:00:00 | 15:30:00 | 22:00:00
 |  |  | Prep |  | Prep |  | Cashier |  | Cashier |  | Maintanence
 |  | [NAME] |  |  |  |  | 17:00:00 | 20:00:00 | 17:00:00 | 20:00:00 |  |  | 17:00:00 | 20:00:00 | 17:00:00 | 20:00:00
 |  |  |  |  |  |  | [NAME] |  | Maintanence |  |  |  | Maintanence |  | Maintanence
 |  | MAN-POWER |  |  |  |  |  |  |  |  |  |  |  |  | Total Payroll Hours
10:00:00 | 10:01:00 | Opening |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total # of Shifts
11:00:00 | 13:01:00 | [NAME]
14:00:00 | 14:02:00 | Afternoon
16:00:00 | 16:01:00 | Evening
17:59:00 | 18:01:00 | Dinner Rush
21:59:00 | 22:00:00 | Closers
09:59:00 | 22:01:00 | Scheduled Man-Power
 |  | Number of Positions
 |  |  | [NAME] | Dinner Rush | [NAME] | Dinner Rush | [NAME] | Dinner Rush | [NAME] | Dinner Rush | [NAME] | Dinner Rush | [NAME] | Dinner Rush | [NAME] | Dinner Rush
 |  | [NAME]
 |  | Cashier
 |  | [NAME]
 |  | Prep
 |  | Maintanence