Spreadsheet: 684849d1593581869-removing-duplicate-dates-from-multiple-cells-late-login-report-example-excel-help-forum
Sheet: Report Template

Agent ID | [NAME] | Calculated Late Times |  |  |  |  |  |  | Agent ID | Date | In
[NAME] | 6/1/20 7:54:23 AM |  |  |  |  | 2020-01-06 00:00:00 |  |  | [NAME] | 2020-06-01 00:00:00 | 07:54:23
[NAME] | 6/2/20 7:54:48 AM |  |  |  | [NAME] | 2020-02-06 00:00:00 |  |  | [NAME] | 2020-06-02 00:00:00 | 07:54:48
[NAME] | 6/3/20 7:54:01 AM |  |  |  | [NAME] | 2020-03-06 00:00:00 |  |  | [NAME] | 2020-06-03 00:00:00 | 07:54:01
[NAME] | 6/3/20 12:54:56 PM |  |  |  | [NAME] | 2020-04-06 00:00:00 |  |  | [NAME] | 2020-06-04 00:00:00 | 07:50:20
[NAME] | 6/3/20 1:07:27 PM |  |  |  | [NAME] | 2020-05-06 00:00:00 |  |  | [NAME] | 2020-06-05 00:00:00 | 07:57:17
[NAME] | 6/4/20 7:50:20 AM |  |  |  | [NAME] | 2020-08-06 00:00:00 |  |  | [NAME] | 2020-06-08 00:00:00 | 07:52:13
[NAME] | 6/5/20 7:57:17 AM |  |  |  | [NAME] | 2020-09-06 00:00:00 |  |  | [NAME] | 2020-06-09 00:00:00 | 07:59:20
[NAME] | 6/5/20 9:24:55 AM |  |  |  | [NAME] | 2020-10-06 00:00:00 |  |  | [NAME] | 2020-06-10 00:00:00 | 08:01:27
[NAME] | 6/5/20 1:06:07 PM |  |  |  | [NAME] | 2020-11-06 00:00:00 |  |  | [NAME] | 2020-06-11 00:00:00 | 08:25:31
[NAME] | 6/8/20 7:52:13 AM |  |  |  | [NAME] | 2020-12-06 00:00:00 |  |  | [NAME] | 2020-06-12 00:00:00 | 07:49:00
[NAME] | 6/8/20 12:59:48 PM |  |  |  | [NAME] | #[NAME]! |  |  | [NAME] | 2020-06-15 00:00:00 | 07:52:38
[NAME] | 6/9/20 7:59:20 AM |  |  |  | aoneal | 2020-01-06 00:00:00 |  |  | [NAME] | 2020-06-16 00:00:00 | 07:50:53
[NAME] | 6/9/20 8:05:10 AM |  |  |  | aoneal | 2020-02-06 00:00:00 |  |  | aoneal | 2020-06-01 00:00:00 | 06:06:11
[NAME] | 6/10/20 8:01:27 AM |  |  |  | aoneal | 2020-04-06 00:00:00 |  |  | aoneal | 2020-06-02 00:00:00 | 05:58:39
[NAME] | 6/10/20 2:51:17 PM |  |  |  | aoneal | 2020-05-06 00:00:00 |  |  | aoneal | 2020-06-04 00:00:00 | 06:02:59
[NAME] | 6/11/20 8:25:31 AM |  |  |  | aoneal | 2020-08-06 00:00:00 |  |  | aoneal | 2020-06-05 00:00:00 | 05:50:07
[NAME] | 6/11/20 8:46:46 AM |  |  |  | aoneal | 2020-09-06 00:00:00 |  |  | aoneal | 2020-06-08 00:00:00 | 05:53:42
[NAME] | 6/11/20 10:18:57 AM |  |  |  | aoneal | 2020-10-06 00:00:00 |  |  | aoneal | 2020-06-09 00:00:00 | 06:01:07
[NAME] | 6/12/20 7:49:00 AM |  |  |  | aoneal | 2020-11-06 00:00:00 |  |  | aoneal | 2020-06-10 00:00:00 | 05:53:36
[NAME] | 6/15/20 7:52:38 AM |  |  |  | aoneal | 2020-12-06 00:00:00 |  |  | aoneal | 2020-06-11 00:00:00 | 06:53:06
[NAME] | 6/15/20 8:30:08 AM |  |  |  | ahawthor | 2020-01-06 00:00:00 |  |  | aoneal | 2020-06-12 00:00:00 | 06:01:45
[NAME] | 6/15/20 1:58:25 PM |  |  |  | ahawthor | 2020-02-06 00:00:00 |  |  | ahawthor | 2020-06-01 00:00:00 | 05:49:56
[NAME] | 6/16/20 7:50:53 AM |  |  |  | ahawthor | 2020-03-06 00:00:00 |  |  | ahawthor | 2020-06-02 00:00:00 | 06:06:16
aoneal | 6/1/20 6:06:11 AM |  |  |  | ahawthor | 2020-04-06 00:00:00 |  |  | ahawthor | 2020-06-03 00:00:00 | 06:03:11
aoneal | 6/2/20 5:58:39 AM |  |  |  | ahawthor | 2020-05-06 00:00:00 |  |  | ahawthor | 2020-06-04 00:00:00 | 06:03:57
aoneal | 6/4/20 6:02:59 AM |  |  |  | ahawthor | 2020-08-06 00:00:00 |  |  | ahawthor | 2020-06-05 00:00:00 | 06:10:30
aoneal | 6/5/20 5:50:07 AM |  |  |  | ahawthor | 2020-09-06 00:00:00 |  |  | ahawthor | 2020-06-08 00:00:00 | 05:58:45
aoneal | 6/5/20 6:34:27 AM |  |  |  | ahawthor | 2020-10-06 00:00:00 |  |  | ahawthor | 2020-06-09 00:00:00 | 06:03:22
aoneal | 6/8/20 5:53:42 AM |  |  |  |  |  |  |  | ahawthor | 2020-06-10 00:00:00 | 06:07:15
aoneal | 6/9/20 6:01:07 AM
aoneal | 6/9/20 9:47:37 AM
aoneal | 6/10/20 5:53:36 AM
aoneal | 6/11/20 6:53:06 AM
aoneal | 6/12/20 6:01:45 AM
ahawthor | 6/1/20 5:49:56 AM
ahawthor | 6/1/20 12:13:20 PM
ahawthor | 6/2/20 6:06:16 AM
ahawthor | 6/2/20 8:08:07 AM
ahawthor | 6/3/20 6:03:11 AM
ahawthor | 6/4/20 6:03:57 AM
ahawthor | 6/5/20 6:10:30 AM
ahawthor | 6/8/20 5:58:45 AM
ahawthor | 6/8/20 10:18:23 AM
ahawthor | 6/8/20 1:21:07 PM
ahawthor | 6/9/20 6:03:22 AM
ahawthor | 6/9/20 7:45:03 AM
ahawthor | 6/10/20 6:07:15 AM
ahawthor | 6/10/20 9:23:58 AM
ahawthor | 6/10/20 9:28:50 AM