Spreadsheet: 136929d1326893244-integrating-a-shift-schedule-and-time-sheets-if-i-had-hair-i-would-pull-it-out-sched-time-sheet-integration
Sheet: Schedule

Site 1 |  | 2012-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Site 1 |  | 2012-01-08 00:00:00
Random Location, Anytown |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | M | T | W | T | F | S | Totals | Random Location, Anytown
1 | Employee 1 | 19:00:00 | 23:59:00 | 00:01:00 | 07:00:00 |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Employee 1 | 19:00:00 | 23:59:00 | 00:01:00 | 07:00:00 |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00
1 | Employee 1 |  |  | 21:30:00 | 23:59:00 | 00:01:00 | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Employee 1 |  |  | 21:30:00 | 23:59:00 | 00:01:00 | 07:00:00
2 | Employee 2 |  |  |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00 | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2 | Employee 2 |  |  |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00 | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00
2 | Employee 2 |  |  |  |  |  |  |  |  |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 00:30:00 |  |  |  |  |  |  |  |  |  | 2 | Employee 2 |  |  |  |  |  |  |  |  |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 00:30:00
3 | Employee 3 | 13:00:00 | 19:00:00 | 17:30:00 | 21:30:00 |  |  |  |  |  |  |  |  | 16:30:00 | 23:59:00 |  |  |  |  |  |  |  |  |  | 3 | Employee 3 | 13:00:00 | 19:00:00 | 17:30:00 | 21:30:00 |  |  |  |  |  |  |  |  | 16:30:00 | 23:59:00
4 | Employee 4 | 00:01:00 | 13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Employee 4 | 00:01:00 | 13:00:00
5 | Employee 5 |  |  |  |  |  |  |  |  |  |  |  |  | 00:30:00 | 09:00:00 |  |  |  |  |  |  |  |  |  | 5 | Employee 5 |  |  |  |  |  |  |  |  |  |  |  |  | 00:30:00 | 09:00:00
Site 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Site 2
Random Location, Anytown |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | M | T | W | T | F | S | Totals | Random Location, Anytown
6 | Employee 6 | 21:00:00 | 23:59:00 | 00:01:00 | 07:00:00 |  |  | 21:00:00 | 23:59:00 | 00:01:00 | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | Employee 6 | 21:00:00 | 23:59:00 | 00:01:00 | 07:00:00 |  |  | 21:00:00 | 23:59:00 | 00:01:00 | 07:00:00
7 | Employee 7 |  |  | 21:00:00 | 23:59:00 | 00:01:00 | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | Employee 7 |  |  | 21:00:00 | 23:59:00 | 00:01:00 | 07:00:00
8 | Employee 8 |  |  |  |  | 21:00:00 | 23:59:00 | 00:01:00 | 07:00:00 | 21:00:00 | 23:59:00 | 00:01:00 | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  | 8 | Employee 8 |  |  |  |  | 21:00:00 | 23:59:00 | 00:01:00 | 07:00:00 | 21:00:00 | 23:59:00 | 00:01:00 | 07:00:00
Site 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Site 2
Random Location, Anytown |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | M | T | W | T | F | S | Totals | Random Location, Anytown
9 | Employee 9 | 00:01:00 | 08:00:00 | 20:00:00 | 23:59:00 | 00:01:00 | 08:00:00 |  |  |  |  |  |  | 20:00:00 | 23:59:00 |  |  |  |  |  |  |  |  |  | 9 | Employee 9 | 00:01:00 | 08:00:00 | 20:00:00 | 23:59:00 | 00:01:00 | 08:00:00 |  |  |  |  |  |  | 20:00:00 | 23:59:00
10 | Employee 10 | 20:00:00 | 23:59:00 | 00:01:00 | 08:00:00 |  |  | 20:00:00 | 23:59:00 | 00:01:00 | 08:00:00 | 20:00:00 | 23:59:00 | 00:01:00 | 08:00:00 |  |  |  |  |  |  |  |  |  | 10 | Employee 10 | 20:00:00 | 23:59:00 | 00:01:00 | 08:00:00 |  |  | 20:00:00 | 23:59:00 | 00:01:00 | 08:00:00 | 20:00:00 | 23:59:00 | 00:01:00 | 08:00:00
11 | Employee 11 |  |  |  |  | 20:00:00 | 23:59:00 | 00:01:00 | 08:00:00 | 20:00:00 | 23:59:00 | 00:01:00 | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  | 11 | Employee 11 |  |  |  |  | 20:00:00 | 23:59:00 | 00:01:00 | 08:00:00 | 20:00:00 | 23:59:00 | 00:01:00 | 08:00:00