Spreadsheet: 164580d1340812679-calculating-time-with-vlookup-new-kitchen-schedule
Sheet: Copy of schedule

 |  |  |  | HOURS |  |  |  | HOURS |  |  |  | HOURS |  |  |  | HOURS |  |  |  | HOURS |  |  |  | HOURS |  |  |  | HOURS | TOTAL HOURS
 | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday |  |  |  | Sunday
 | IN | - | OUT |  | IN | - | OUT |  | IN | - | OUT |  | IN | - | OUT |  | IN | - | OUT |  | IN | - | OUT |  | IN | - | OUT |  |  |  | M |  | T |  | W |  | T |  | F |  | S |  | S
[NAME] | 08:00:00 | - | 16:00:00 |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
 | OFF | - | OFF |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
Line Cooks
Concha | OFF | - |  |  | OFF | - |  |  | 05:30:00 | - | 14:00:00 |  | 06:00:00 | - | 14:00:00 |  | 06:00:00 | - | 14:00:00 |  | 05:30:00 | - | 12:00:00 |  | 06:00:00 | - | 14:00:00
 |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
[NAME] | 05:30:00 | - | 14:00:00 |  | 06:00:00 | - | 14:00:00 |  | 06:00:00 | - | 14:00:00 |  | 05:30:00 | - | 14:00:00 |  | 05:30:00 | - | 14:00:00 |  | OFF | - |  |  | OFF | -
 |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
Maria | 06:00:00 | - | 12:00:00 |  | 05:30:00 | - | 14:00:00 |  | R-OFF | - |  |  | R-OFF | - |  |  | 10:00:00 | - | 14:00:00 |  | 06:00:00 | - | 14:00:00 |  | 06:00:00 | - | 14:00:00
 |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
Dustin | OFF | - |  |  | OFF | - |  |  | 18:00:00 | - | CL |  | 15:00:00 | - | 21:00:00 |  | 15:00:00 | - | CL |  | 15:00:00 | - | CL |  | 15:00:00 | - | CL
 |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
[NAME] |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
 |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
New Hire |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
 |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
 |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
 |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
Dish
Gerardo |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
 |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
Eduardo |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
 |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
Jeremy |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
 |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
[NAME] |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
 |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
Stew |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
 |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
BREAK POLICY | BREAKS MUST BE TAKEN DAILY!  PUNCH OUT FOR BREAKS!
 | BREAKS MUST BE AT LEAST 20 MINUTES AND NO MORE THAN THIRTY MINUTES. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL HOURS
Rooms | 43 |  |  |  | 30 |  |  |  | 19 |  |  |  | 14 |  |  |  | 29 |  |  |  | 41 |  |  |  | 7
Guest | 118 |  |  |  | 126 |  |  |  | 123 |  |  |  | 46 |  |  |  | 22 |  |  |  | 68 |  |  |  | 11
DR PD |  |  |  |  |  |  |  |  |  |  |  |  | ROTARY=6:45AM
Breakfast
lunch
Dinner |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 150