Spreadsheet: 197493d1354385906-help-with-referencing-ranges-schedule-template1
Sheet: All

Employee List of Hours & Location
 |  | Total
Name | Location | Date | In | Out | Total
[NAME] | Site 1 | 2012-11-26 00:00:00 | 08:00:00 | 16:00:00
[NAME] | Site 2 | 2012-11-29 00:00:00 | 09:00 | 15:00
[NAME] | Site 3 | 2012-11-27 00:00:00 | 06:30:00 | 1900-01-01 11:54:26.367000
[NAME] | Site 4 | 2012-11-30 00:00:00 | 08:42:00 | 17:30:00
[NAME] | Site 5 | 2012-11-29 00:00:00 | 10:16:00 | 12:40:00
[NAME] | Site 6 | 2012-12-01 00:00:00 | 13:29:00 | 18:40:00
AN Other 5 | Site 7 | 2012-11-27 00:00:00 | 15:06:00 | 19:27:00
AN Other 6 | Site 8 | 2012-12-02 00:00:00 | 16:44:00 | 18:11:00
AN Other 7 | Site 9 | 2012-12-01 00:00:00 | 10:21:00 | 18:36:00
AN Other 8 | Site 10 | 2012-11-27 00:00:00 | 08:44:00 | 18:11:00
AN Other 9 | Site 11 | 2012-12-01 00:00:00 | 11:17:00 | 13:49:00
AN Other 10 | Site 12 | 2012-11-27 00:00:00 | 10:07:00 | 18:16:00
AN Other 11 | Site 13 | 2012-11-27 00:00:00 | 18:10:00 | 18:16:00
AN Other 12 | Site 14 | 2012-11-26 00:00:00 |  | 12:34:00
AN Other 13 | Site 15 | 2012-12-02 00:00:00 | 14:05:00 | 14:43:00
AN Other 14 | Site 16 | 2012-11-26 00:00:00 | 08:08:00 | 08:24:00
AN Other 15 | Site 17 | 2012-11-30 00:00:00 | 12:36:00 | 19:08:00
AN Other 16 | Site 18 | 2012-11-26 00:00:00 | 10:25:00 | 11:47:00
AN Other 17 | Site 1 | 2012-11-30 00:00:00 | 06:30:00 | 10:13:00
AN Other 18 | Site 2 | 2012-12-02 00:00:00 | 13:30:00 | 19:08:00
AN Other 19 | Site 3 | 2012-12-01 00:00:00 | 08:00:00 | 14:45:00
AN Other 20 | Site 4 | 2012-11-30 00:00:00 | 06:13:00 | 12:33:00
AN Other 21 | Site 5 | 2012-12-02 00:00:00 | 10:19:00 | 17:25:00
AN Other 22 | Site 6 | 2012-11-29 00:00:00 | 06:35:00 | 08:48:00
AN Other 23 | Site 7 | 2012-12-01 00:00:00 | 16:13:00 | 18:00:00
AN Other 24 | Site 8 | 2012-11-26 00:00:00 | 07:38:00 | 11:10:00
AN Other 13 | Site 9 | 2012-11-26 00:00:00 | 08:00:00 | 16:00:00
AN Other 14 | Site 10 | 2012-11-29 00:00:00 | 09:00 | 15:00
AN Other 15 | Site 11 | 2012-11-27 00:00:00 | 06:30:00 | 1900-01-01 11:54:26.367000
AN Other 16 | Site 12 | 2012-11-30 00:00:00 | 08:42:00 | 17:30:00
AN Other 17 | Site 13 | 2012-11-29 00:00:00 | 10:16:00 | 12:40:00
AN Other 18 | Site 14 | 2012-12-01 00:00:00 | 13:29:00 | 18:40:00
AN Other 19 | Site 15 | 2012-11-27 00:00:00 | 15:06:00 | 19:27:00
AN Other 20 | Site 16 | 2012-12-02 00:00:00 | 16:44:00 | 18:11:00
AN Other 21 | Site 17 | 2012-12-01 00:00:00 | 10:21:00 | 18:36:00
AN Other 22 | Site 18 | 2012-11-27 00:00:00 | 08:44:00 | 18:11:00
AN Other 23 | Site 1 | 2012-12-01 00:00:00 | 11:17:00 | 13:49:00
AN Other 24 | Site 2 | 2012-11-27 00:00:00 | 10:07:00 | 18:16:00
AN Other 13 | Site 3 | 2012-11-27 00:00:00 | 18:10:00 | 18:16:00
AN Other 14 | Site 4 | 2012-11-26 00:00:00 |  | 12:34:00
AN Other 15 | Site 5 | 2012-12-02 00:00:00 | 14:05:00 | 14:43:00
AN Other 16 | Site 6 | 2012-11-26 00:00:00 | 08:08:00 | 08:24:00
AN Other 17 | Site 7 | 2012-11-30 00:00:00 | 12:36:00 | 19:08:00
AN Other 18 | Site 8 | 2012-11-26 00:00:00 | 10:25:00 | 11:47:00
AN Other 19 | Site 9 | 2012-11-30 00:00:00 | 06:30:00 | 10:13:00
AN Other 20 | Site 10 | 2012-12-02 00:00:00 | 13:30:00 | 19:08:00
AN Other 21 | Site 11 | 2012-12-01 00:00:00 | 08:00:00 | 14:45:00
AN Other 22 | Site 12 | 2012-11-30 00:00:00 | 06:13:00 | 12:33:00
AN Other 23 | Site 13 | 2012-12-02 00:00:00 | 10:19:00 | 17:25:00
AN Other 24 | Site 14 | 2012-11-29 00:00:00 | 06:35:00 | 08:48:00
[NAME] | Site 15 | 2012-12-01 00:00:00 | 16:13:00 | 18:00:00
[NAME] | Site 16 | 2012-11-26 00:00:00 | 07:38:00 | 11:10:00
[NAME] | Site 17 | 2012-11-26 00:00:00 | 08:00:00 | 16:00:00
[NAME] | Site 18 | 2012-11-29 00:00:00 | 09:00 | 15:00
[NAME] | Site 1 | 2012-11-27 00:00:00 | 06:30:00 | 1900-01-01 11:54:26.367000
[NAME] | Site 2 | 2012-11-30 00:00:00 | 08:42:00 | 17:30:00
AN Other 5 | Site 3 | 2012-11-29 00:00:00 | 10:16:00 | 12:40:00
AN Other 6 | Site 4 | 2012-12-01 00:00:00 | 13:29:00 | 18:40:00
AN Other 7 | Site 5 | 2012-11-27 00:00:00 | 15:06:00 | 19:27:00
AN Other 8 | Site 6 | 2012-12-02 00:00:00 | 16:44:00 | 18:11:00
AN Other 9 | Site 7 | 2012-12-01 00:00:00 | 10:21:00 | 18:36:00
AN Other 10 | Site 8 | 2012-11-27 00:00:00 | 08:44:00 | 18:11:00
AN Other 11 | Site 9 | 2012-12-01 00:00:00 | 11:17:00 | 13:49:00
AN Other 12 | Site 10 | 2012-11-27 00:00:00 | 10:07:00 | 18:16:00
AN Other 13 | Site 11 | 2012-11-27 00:00:00 | 18:10:00 | 18:16:00
AN Other 14 | Site 12 | 2012-11-26 00:00:00 |  | 12:34:00
AN Other 15 | Site 13 | 2012-12-02 00:00:00 | 14:05:00 | 14:43:00
AN Other 16 | Site 14 | 2012-11-26 00:00:00 | 08:08:00 | 08:24:00
AN Other 17 | Site 15 | 2012-11-30 00:00:00 | 12:36:00 | 19:08:00
AN Other 18 | Site 16 | 2012-11-26 00:00:00 | 10:25:00 | 11:47:00
AN Other 19 | Site 17 | 2012-11-30 00:00:00 | 06:30:00 | 10:13:00
AN Other 20 | Site 18 | 2012-12-02 00:00:00 | 13:30:00 | 19:08:00
AN Other 21 | Site 1 | 2012-12-01 00:00:00 | 08:00:00 | 14:45:00
AN Other 22 | Site 2 | 2012-11-30 00:00:00 | 06:13:00 | 12:33:00
AN Other 23 | Site 3 | 2012-12-02 00:00:00 | 10:19:00 | 17:25:00
AN Other 24 | Site 4 | 2012-11-29 00:00:00 | 06:35:00 | 08:48:00
AN Other 13 | Site 5 | 2012-12-01 00:00:00 | 16:13:00 | 18:00:00
AN Other 14 | Site 6 | 2012-11-26 00:00:00 | 07:38:00 | 11:10:00
AN Other 15 | Site 7 | 2012-11-26 00:00:00 | 08:00:00 | 16:00:00
AN Other 16 | Site 8 | 2012-11-29 00:00:00 | 09:00 | 15:00
AN Other 17 | Site 9 | 2012-11-27 00:00:00 | 06:30:00 | 1900-01-01 11:54:26.367000
AN Other 18 | Site 10 | 2012-11-30 00:00:00 | 08:42:00 | 17:30:00
AN Other 19 | Site 11 | 2012-11-29 00:00:00 | 10:16:00 | 12:40:00
AN Other 20 | Site 12 | 2012-12-01 00:00:00 | 13:29:00 | 18:40:00
AN Other 21 | Site 13 | 2012-11-27 00:00:00 | 15:06:00 | 19:27:00
AN Other 22 | Site 14 | 2012-12-02 00:00:00 | 16:44:00 | 18:11:00
AN Other 23 | Site 15 | 2012-12-01 00:00:00 | 10:21:00 | 18:36:00
AN Other 24 | Site 16 | 2012-11-27 00:00:00 | 08:44:00 | 18:11:00
AN Other 13 | Site 17 | 2012-12-01 00:00:00 | 11:17:00 | 13:49:00
AN Other 14 | Site 18 | 2012-11-27 00:00:00 | 10:07:00 | 18:16:00
AN Other 15 | Site 1 | 2012-11-27 00:00:00 | 12:00:00 | 18:16:00
AN Other 16 | Site 2 | 2012-11-26 00:00:00 |  | 12:34:00
AN Other 17 | Site 3 | 2012-12-02 00:00:00 | 14:05:00 | 14:43:00
AN Other 18 | Site 4 | 2012-11-26 00:00:00 | 08:08:00 | 08:24:00
AN Other 19 | Site 5 | 2012-11-30 00:00:00 | 12:36:00 | 19:08:00
AN Other 20 | Site 6 | 2012-11-26 00:00:00 | 10:25:00 | 11:47:00