Spreadsheet: 879764d1727317770-employee-tardiness-formula-requested-tardiness-formula-request-sample-3-1-
Sheet: Sheet1

August |  |  | Helper |  | September |  |  |  |  | with helper column D | Without Helper
Agent ID | Logged On DateTime |  |  |  | Agent ID | Logged On DateTime |  |  |  | # of Lates
Agent3 | 8/2/24 8:13:27 AM |  |  |  | Agent3 | 2024-09-03 08:25:24 |  |  | Agent3
 |  |  |  |  |  |  |  |  | Agent4
 | 8/5/24 8:21:35 AM |  |  |  |  | 9/4/24 7:52:09 AM
 | 8/5/24 3:31:24 PM
 |  |  |  |  |  | 9/5/24 8:15:01 AM |  |  | In August: Agent3 had 33 rows In September: Agent3 had 54 rows  In August: Agent 4 had 70 rows In September: Agent4 had 40 rows
 | 8/6/24 8:24:21 AM |  |  |  |  | 9/5/24 12:14:55 PM
 |  |  |  |  |  | 9/5/24 3:29:28 PM
 | 8/7/24 8:13:55 AM
 |  |  |  |  |  | 9/6/24 8:25:39 AM
 | 8/8/24 10:56:22 AM |  |  |  |  | 9/6/24 11:52:55 AM
 |  |  |  |  |  | 9/6/24 2:46:52 PM
 | 8/9/24 8:17:54 AM
 |  |  |  |  |  | 9/9/24 8:17:12 AM
 | 8/12/24 8:03:35 AM
 |  |  |  |  |  | 9/10/24 8:08:40 AM
 | 8/13/24 8:17:37 AM
 |  |  |  |  |  | 9/11/24 7:33:47 AM
 | 8/14/24 8:13:07 AM |  |  |  |  | 9/11/24 3:40:09 PM
 | 8/15/24 8:19:18 AM |  |  |  |  | 9/12/24 8:14:11 AM
 |  |  |  |  |  | 9/12/24 8:53:24 AM
 | 8/16/24 7:59:05 AM |  |  |  |  | 9/12/24 12:14:24 PM
 | 8/19/24 7:33:44 AM |  |  |  |  | 9/13/24 8:12:48 AM
 | 8/19/24 9:55:00 AM
 |  |  |  |  |  | 9/16/24 8:12:00 AM
 | 8/20/24 8:14:05 AM
 |  |  |  |  |  | 9/17/24 8:12:38 AM
 | 8/21/24 8:08:57 AM |  |  |  |  | 9/17/24 1:52:39 PM
 |  |  |  |  |  | 9/17/24 2:07:02 PM
 | 8/22/24 7:43:24 AM |  |  |  |  | 9/17/24 3:26:18 PM
 |  |  |  |  |  | 9/17/24 3:34:12 PM
Agent3 |  |  |  |  |  | 9/17/24 3:50:37 PM
Agent4 | 8/1/24 8:11:22 AM
 |  |  |  |  |  | 9/18/24 7:30:19 AM
 | 8/2/24 8:16:26 AM |  |  |  |  | 9/18/24 8:46:03 AM
 |  |  |  |  |  | 9/18/24 2:44:29 PM
 | 8/5/24 8:04:14 AM |  |  |  |  | 9/18/24 3:00:13 PM
 |  |  |  |  |  | 9/18/24 3:07:04 PM
 | 8/6/24 8:08:20 AM |  |  |  |  | 9/18/24 4:09:43 PM
 | 8/6/24 11:49:40 AM
 | 8/6/24 12:03:10 PM |  |  |  |  | 9/19/24 8:16:00 AM
 |  |  |  |  |  | 9/19/24 9:15:35 AM
 | 8/7/24 8:07:22 AM |  |  |  |  | 9/19/24 12:56:14 PM
 | 8/8/24 8:08:16 AM |  |  |  |  | 9/20/24 8:21:15 AM
 |  |  |  |  |  | 9/20/24 2:19:10 PM
 | 8/9/24 8:16:43 AM
 | 8/9/24 8:18:27 AM |  |  |  |  | 9/23/24 8:21:21 AM
 | 8/9/24 9:43:28 AM
 | 8/9/24 4:02:52 PM |  |  |  |  | 9/24/24 8:25:42 AM
 |  |  |  |  |  | 9/24/24 1:37:42 PM
 | 8/12/24 8:30:45 AM
 | 8/12/24 8:35:08 AM |  |  |  | Agent3
 | 8/12/24 11:46:11 AM |  |  |  | Agent4 | 9/3/24 8:01:56 AM
 | 8/12/24 12:33:25 PM
 |  |  |  |  |  | 9/4/24 8:20:50 AM
 | 8/13/24 8:17:53 AM |  |  |  |  | 9/4/24 12:50:51 PM
 | 8/13/24 9:25:25 AM |  |  |  |  | 9/4/24 3:26:42 PM
 | 8/14/24 8:15:44 AM |  |  |  |  | 9/5/24 7:20:01 AM
 | 8/14/24 11:49:39 AM
 | 8/14/24 12:21:45 PM |  |  |  |  | 9/6/24 8:09:15 AM
 |  |  |  |  |  | 9/6/24 1:56:45 PM
 | 8/15/24 8:19:16 AM
 | 8/15/24 2:34:52 PM |  |  |  |  | 9/9/24 8:24:25 AM
 | 8/16/24 8:09:42 AM |  |  |  |  | 9/10/24 8:21:04 AM
 | 8/16/24 8:14:19 AM |  |  |  |  | 9/10/24 11:42:31 AM
 | 8/16/24 8:57:10 AM
 | 8/16/24 4:05:59 PM |  |  |  |  | 9/11/24 8:07:46 AM
 | 8/19/24 8:14:57 AM |  |  |  |  | 9/12/24 7:50:34 AM
 | 8/19/24 12:07:21 PM
 | 8/19/24 12:12:13 PM |  |  |  |  | 9/13/24 8:10:13 AM
 | 8/19/24 4:28:20 PM
 |  |  |  |  |  | 9/16/24 7:34:27 AM
 | 8/20/24 8:16:22 AM
 |  |  |  |  |  | 9/17/24 8:12:04 AM
 | 8/21/24 7:49:17 AM |  |  |  |  | 9/17/24 12:48:47 PM
 | 8/21/24 12:00:17 PM |  |  |  |  | 9/17/24 5:10:18 PM
 | 8/21/24 12:17:46 PM
 | 8/21/24 12:23:25 PM |  |  |  |  | 9/18/24 8:19:08 AM
 |  |  |  |  |  | 9/18/24 12:00:58 PM
 | 8/22/24 8:14:17 AM
 | 8/22/24 8:23:23 AM |  |  |  |  | 9/19/24 7:36:41 AM
 | 8/22/24 3:06:44 PM
 |  |  |  |  |  | 9/20/24 8:15:02 AM
 | 8/26/24 8:24:29 AM
 | 8/26/24 12:51:11 PM |  |  |  |  | 9/23/24 7:43:01 AM
 | 8/26/24 4:18:25 PM
 |  |  |  |  |  | 9/24/24 8:04:12 AM
 | 8/27/24 8:14:06 AM |  |  |  |  | 9/24/24 2:42:36 PM
 | 8/27/24 1:54:06 PM
 |  |  |  |  | Agent4
 | 8/28/24 7:32:12 AM
 | 8/28/24 8:44:42 AM
 | 8/29/24 8:13:21 AM
 | 8/29/24 10:56:21 AM
 | 8/30/24 8:08:12 AM
 | 08/30/2024
Agent4