Spreadsheet: 552810d1513789779-getting-first-in-and-last-out-of-a-report-k1
Sheet: Sheet1

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