Spreadsheet: 164580d1340812679-calculating-time-with-vlookup-new-kitchen-schedule
Sheet: Schedule to post

 | 2012-06-25 00:00:00 |  |  | 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] | 6:00 AM | - | 6:00 AM |  | 1:30 PM | - | 1:30 PM |  | 5:00 AM | - | 1:30 PM |  |  | - |  |  | 8:00 AM | - | 4:00 PM |  |  | - |  |  |  | -
 | 8:00 AM | - | 8:30 AM |  | 1:00 PM | - | 1:30 PM |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
Line Cooks
Concha | 5:00 AM | - | 6:00 AM |  | 5:00 AM | - | 6:00 AM |  | 05:30:00 | - | 14:00:00 |  | 06:00:00 | - | 2:30 PM |  |  | - |  |  | 05:30:00 | - | 2:00 PM |  | 06:00:00 | - | 2:30 PM
 | 5:30 AM | - | 7:00 AM |  | 5:00 AM | - | 6:30 AM |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
[NAME] | 05:30:00 | - | 7:30 AM |  | 06:00:00 | - | 8:00 AM |  |  | - |  |  | 05:30:00 | - | 14:00:00 |  | 05:30:00 | - | 14:00:00 |  | OFF | - |  |  | OFF | -
 | 5:00 AM | - | 7:30 AM |  | 5:00 AM | - | 7:30 AM |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
Maria | 06:00:00 | - | 9:00 AM |  | 5:30 AM | - | 8:30 AM |  | R-OFF | - |  |  | R-OFF | - |  |  | 1:00 PM | - | 14:00:00 |  | 06:00:00 | - | 14:00:00 |  | 06:00:00 | - | 14:00:00
 | 5:00 AM | - | 8:30 AM |  | 5:00 AM | - | 8:30 AM |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
Dustin | 5:00 AM | - | 9:00 AM |  | 5:00 AM | - | 9:00 AM |  | 5:00 AM | - | 1:30 PM |  | 15:00:00 | - | 11:30 PM |  | 15:00:00 | - | CL |  | 15:00:00 | - | CL |  | 15:00:00 | - | CL
 | 5:00 AM | - | 9:30 AM |  | 5:00 AM | - | 9:30 AM |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
[NAME] | 5:00 AM | - | 10:00 AM |  | 5:00 AM | - | 10:00 AM |  | 6:00 AM | - | 2:30 PM |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
 | 5:00 AM | - | 10:30 AM |  | 5:00 AM | - | 10:30 AM |  |  | - |  |  | 6:30 AM | - | 3:00 PM |  |  | - |  |  |  | - |  |  |  | -
New Hire | 5:00 AM | - | 11:00 AM |  | 5:00 AM | - | 11:00 AM |  |  | - |  |  |  | - |  |  |  | - |  |  | 6:30 AM | - | 3:00 PM |  |  | -
 | 5:00 AM | - | 11:30 AM |  | 12:00 PM | - | 6:30 PM |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  | 8:00 AM | - | 4:30 PM
 | 5:00 AM | - | 12:00 PM |  | 5:00 AM | - | 12:00 PM |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
 | 5:00 AM | - | 12:30 PM |  | 5:00 AM | - | 12:30 PM |  | 9:30 AM | - | 6:00 PM |  |  | - |  |  | 10:00 AM | - | 6:30 PM |  | 9:00 AM | - | 5:30 PM |  |  | -
Dish
Gerardo | 5:00 AM | - | 1:00 PM |  | 5:00 AM | - | 1:00 PM |  | 8:30 AM | - | 5:00 PM |  |  | - |  |  |  | - |  |  |  | - |  |  |  | -
 | 5:00 AM | - | 1:30 PM |  | 5:30 AM | - | 2:00 PM |  |  | - |  |  | 5:00 AM | - | 1:30 PM |  |  | - |  |  |  | - |  |  |  | -
Eduardo | 5:00 AM | - | 2:00 PM |  | 5:00 AM | - | 2:00 PM |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  | 7:00 AM | - | 3:30 PM
 | 5:00 AM | - | 2:30 PM |  | 5:00 AM | - | 2:30 PM |  |  | - |  |  |  | - |  |  |  | - |  |  | 10:30 AM | - | 7:00 PM |  | 7:30 AM | - | 4:00 PM
Jeremy | 5:00 AM | - | 3:00 PM |  | 5:00 AM | - | 3:00 PM |  |  | - |  |  |  | - |  |  | 3:00 PM | - | 11:30 PM |  | 11:30 AM | - | 8:00 PM |  |  | -
 | 5:00 AM | - | 3:30 PM |  | 5:00 AM | - | 3:30 PM |  |  | - |  |  |  | - |  |  |  | - |  |  | 11:00 AM | - | 7:30 PM |  |  | -
[NAME] | 5:00 AM | - | 4:00 PM |  | 5:00 AM | - | 4:00 PM |  |  | - |  |  | 1:00 PM | - | 9:30 PM |  | 12:00 PM | - | 8:30 PM |  |  | - |  |  |  | -
 | 5:00 AM | - | 4:30 PM |  | 5:00 AM | - | 4:30 PM |  |  | - |  |  |  | - |  |  | 12:30 PM | - | 9:00 PM |  |  | - |  |  |  | -
Stew | 5:00 AM | - | 5:00 PM |  | 5:00 AM | - | 5:00 PM |  |  | - |  |  | 1:30 PM | - | 10:00 PM |  |  | - |  |  |  | - |  |  |  | -
 | 5:00 AM | - | 5:30 PM |  | 5:00 AM | - | 5:30 PM |  | 5:30 AM | - | 2:00 PM |  | 5:00 AM | - | 1:30 PM |  |  | - |  |  |  | - |  |  |  | -
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