Spreadsheet: 552789d1513777118-getting-first-in-and-last-out-of-a-report-sample-time-report
Sheet: Sheet1

Date | Company | Name | PID | In/Out | Time | Reader |  |  | Date | Company | Department | Shift | In | Out |  | Hours
12/01/2017 |  | Employee 1 |  | In | 06:26 |  | Employee 1 |  | 2017-11-27 00:00:00 |  |  | DS
12/01/2017 |  | Employee 1 |  | Out | 16:15 |  |  |  | 2017-11-28 00:00:00 |  |  | DS
12/01/2017 |  | Employee 2 |  | In | 05:54 |  |  |  | 2017-11-29 00:00:00 |  |  | DS
12/01/2017 |  | Employee 2 |  | Out | 10:57 |  |  |  | 2017-11-30 00:00:00 |  |  | DS
12/01/2017 |  | Employee 2 |  | In | 11:13 |  |  |  | 2017-12-01 00:00:00 |  |  | DS | 06:26 | 16:15
12/01/2017 |  | Employee 2 |  | Out | 15:32 |  |  |  | 2017-12-02 00:00:00 |  |  | DS
12/01/2017 |  | Employee 2 |  | In | 15:33 |  |  |  | 2017-12-03 00:00:00 |  |  | DS
12/01/2017 |  | Employee 2 |  | Out | 15:34
12/01/2017 |  | Employee 3 |  | In | 05:35
12/01/2017 |  | Employee 3 |  | Out | 07:46 |  | Employee 2 |  | Date | Company | Department | Shift | In | Out |  | Hours
12/01/2017 |  | Employee 3 |  | In | 07:53 |  |  |  | 2017-11-27 00:00:00 |  |  | DS
12/01/2017 |  | Employee 3 |  | Out | 08:16 |  |  |  | 2017-11-28 00:00:00 |  |  | DS
12/01/2017 |  | Employee 3 |  | In | 08:18 |  |  |  | 2017-11-29 00:00:00 |  |  | DS
12/01/2017 |  | Employee 3 |  | Out | 08:43 |  |  |  | 2017-11-30 00:00:00 |  |  | DS
12/01/2017 |  | Employee 3 |  | In | 08:47 |  |  |  | 2017-12-01 00:00:00 |  |  | DS | 05:54 | 15:34
12/01/2017 |  | Employee 3 |  | Out | 11:30 |  |  |  | 2017-12-02 00:00:00 |  |  | DS
12/01/2017 |  | Employee 3 |  | Out | 11:58 |  |  |  | 2017-12-03 00:00:00 |  |  | DS
12/01/2017 |  | Employee 3 |  | In | 12:02
12/01/2017 |  | Employee 3 |  | Out | 12:51
12/01/2017 |  | Employee 3 |  | In | 12:57 |  |  |  | Date | Company | Department | Shift | In | Out |  | Hours
12/01/2017 |  | Employee 3 |  | Out | 13:10 |  | Employee 3 |  | 2017-11-27 00:00:00 |  |  | DS
12/01/2017 |  | Employee 3 |  | In | 13:11 |  |  |  | 2017-11-28 00:00:00 |  |  | DS
12/01/2017 |  | Employee 3 |  | Out | 13:54 |  |  |  | 2017-11-29 00:00:00 |  |  | DS
12/01/2017 |  | Employee 3 |  | In | 13:58 |  |  |  | 2017-11-30 00:00:00 |  |  | DS
12/01/2017 |  | Employee 3 |  | Out | 15:26 |  |  |  | 2017-12-01 00:00:00 |  |  | DS | 05:35 | 15:26
12/01/2017 |  | Employee 4 |  | In | 06:56 |  |  |  | 2017-12-02 00:00:00 |  |  | DS
12/01/2017 |  | Employee 4 |  | Out | 07:00 |  |  |  | 2017-12-03 00:00:00 |  |  | DS
12/01/2017 |  | Employee 4 |  | In | 07:07
12/01/2017 |  | Employee 4 |  | Out | 07:08
12/01/2017 |  | Employee 4 |  | Out | 07:19 |  |  |  | Date | Company | Department | Shift | In | Out |  | Hours
12/01/2017 |  | Employee 4 |  | In | 08:01 |  | Employee 4 |  | 2017-11-27 00:00:00 |  |  | DS
12/01/2017 |  | Employee 4 |  | Out | 08:03 |  |  |  | 2017-11-28 00:00:00 |  |  | DS
12/01/2017 |  | Employee 4 |  | In | 08:22 |  |  |  | 2017-11-29 00:00:00 |  |  | DS
12/01/2017 |  | Employee 4 |  | In | 08:32 |  |  |  | 2017-11-30 00:00:00 |  |  | DS
12/01/2017 |  | Employee 4 |  | Out | 09:25 |  |  |  | 2017-12-01 00:00:00 |  |  | DS | 06:56 | 16:10
12/01/2017 |  | Employee 4 |  | In | 09:51 |  |  |  | 2017-12-02 00:00:00 |  |  | DS
12/01/2017 |  | Employee 4 |  | Out | 10:04 |  |  |  | 2017-12-03 00:00:00 |  |  | DS
12/01/2017 |  | Employee 4 |  | In | 10:13
12/01/2017 |  | Employee 4 |  | In | 10:40
12/01/2017 |  | Employee 4 |  | Out | 11:02
12/01/2017 |  | Employee 4 |  | In | 13:28
12/01/2017 |  | Employee 4 |  | Out | 13:57
12/01/2017 |  | Employee 4 |  | In | 15:41
12/01/2017 |  | Employee 4 |  | Out | 16:10