Spreadsheet: 807263d1669823221-using-unique-and-sumifs-on-data-timesheet-for-excel-forums-1-ans-2
Sheet: Sheet1

 |  |  |  |  | staff name
Date | clock in | Date | clock out | HRS WORKEd | Hrs. Worked | unique formula | time worked that day
 |  |  |  |  |  |  |  |  |  | Dates | Total time worked
2022-10-28 00:00:00 | 10:01:32 | 2022-10-28 00:00:00 | 15:37:47 | 05:36:15 | -
2022-10-28 00:00:00 | 16:36:48 | 2022-10-28 00:00:00 | 22:50:20 | 06:13:32 | - | 2022-10-29 00:00:00 | 07:07:54 |  |  | 2022-10-29 00:00:00 | 07:07:54
2022-10-29 00:00:00 | 14:57:31 | 2022-10-29 00:00:00 | 18:46:59 | 03:49:28 | - | 2022-10-30 00:00:00 | 10:36:30 |  |  | 2022-10-30 00:00:00 | 10:36:30
2022-10-29 00:00:00 | 19:22:08 | 2022-10-29 00:00:00 | 20:10:16 | 00:48:08 | - | 2022-11-02 00:00:00 | 11:07:42 |  |  | 2022-11-02 00:00:00 | 11:07:42
2022-10-29 00:00:00 | 20:10:30 | 2022-10-29 00:00:00 | 22:40:48 | 02:30:18 | - | 2022-11-03 00:00:00 | 11:26:05 |  |  | 2022-11-03 00:00:00 | 11:26:05
2022-10-30 00:00:00 | 10:06:22 | 2022-10-30 00:00:00 | 12:59:10 | 02:52:48 | - | 2022-11-05 00:00:00 | 12:35:45 |  |  | 2022-11-05 00:00:00 | 12:35:45
2022-10-30 00:00:00 | 13:08:23 | 2022-10-30 00:00:00 | 15:56:25 | 02:48:02 | - | 2022-11-06 00:00:00 | 05:42:40 |  |  | 2022-11-06 00:00:00 | 05:42:40
2022-10-30 00:00:00 | 16:56:42 | 2022-10-30 00:00:00 | 21:52:22 | 04:55:40 | - | 2022-11-07 00:00:00 | 11:35:53 |  |  | 2022-11-07 00:00:00 | 11:35:53
2022-11-02 00:00:00 | 09:55:52 | 2022-11-02 00:00:00 | 15:00:32 | 05:04:40 | - | 2022-11-08 00:00:00 | 05:20:47 |  |  | 2022-11-08 00:00:00 | 05:20:47
2022-11-02 00:00:00 | 16:01:07 | 2022-11-02 00:00:00 | 22:04:09 | 06:03:02 | - | 2022-11-11 00:00:00 | 10:39:02 |  |  | 2022-11-11 00:00:00 | 10:39:02
2022-11-03 00:00:00 | 09:16:53 | 2022-11-03 00:00:00 | 12:28:39 | 03:11:46 | - | 2022-11-12 00:00:00 | 07:39:23 |  |  | 2022-11-12 00:00:00 | 07:39:23
2022-11-03 00:00:00 | 12:35:38 | 2022-11-03 00:00:00 | 16:14:35 | 03:38:57 | - | 2022-11-16 00:00:00 | 10:47:33 |  |  | 2022-11-16 00:00:00 | 10:47:33
2022-11-03 00:00:00 | 17:23:34 | 2022-11-03 00:00:00 | 17:28:40 | 00:05:06 | - | 2022-11-17 00:00:00 | 10:59:45 |  |  | 2022-11-17 00:00:00 | 10:59:45
2022-11-03 00:00:00 | 17:35:34 | 2022-11-03 00:00:00 | 22:05:50 | 04:30:16 | - | 2022-11-18 00:00:00 | 07:15:16 |  |  | 2022-11-18 00:00:00 | 07:15:16
2022-11-05 00:00:00 | 08:53:01 | 2022-11-05 00:00:00 | 11:07:17 | 02:14:16 | - | 2022-11-19 00:00:00 | 11:41:02 |  |  | 2022-11-19 00:00:00 | 11:41:02
2022-11-05 00:00:00 | 11:12:27 | 2022-11-05 00:00:00 | 16:32:38 | 05:20:11 | - | 2022-11-21 00:00:00 | 10:43:31 |  |  | 2022-11-21 00:00:00 | 10:43:31
2022-11-05 00:00:00 | 17:29:03 | 2022-11-05 00:00:00 | 22:30:21 | 05:01:18 | - | 2022-11-22 00:00:00 | 10:47:24 |  |  | 2022-11-22 00:00:00 | 10:47:24
2022-11-06 00:00:00 | 15:49:30 | 2022-11-06 00:00:00 | 18:10:49 | 02:21:19 | - | 2022-11-25 00:00:00 | 11:11:22 |  |  | 2022-11-25 00:00:00 | 11:11:22
2022-11-06 00:00:00 | 18:38:58 | 2022-11-06 00:00:00 | 22:00:19 | 03:21:21 | -
2022-11-07 00:00:00 | 09:56:01 | 2022-11-07 00:00:00 | 13:56:30 | 04:00:29 | -
2022-11-07 00:00:00 | 14:09:05 | 2022-11-07 00:00:00 | 18:23:23 | 04:14:18 | -
2022-11-07 00:00:00 | 18:34:25 | 2022-11-07 00:00:00 | 21:55:31 | 03:21:06 | -
2022-11-08 00:00:00 | 08:56:12 | 2022-11-08 00:00:00 | 13:06:58 | 04:10:46 | -
2022-11-08 00:00:00 | 13:53:27 | 2022-11-08 00:00:00 | 15:03:28 | 01:10:01 | -
2022-11-11 00:00:00 | 10:54:12 | 2022-11-11 00:00:00 | 16:30:21 | 05:36:09 | -
2022-11-11 00:00:00 | 17:28:50 | 2022-11-11 00:00:00 | 20:14:41 | 02:45:51 | -
2022-11-11 00:00:00 | 20:26:16 | 2022-11-11 00:00:00 | 22:43:18 | 02:17:02 | -
2022-11-12 00:00:00 | 13:56:14 | 2022-11-12 00:00:00 | 16:59:49 | 03:03:35 | -
2022-11-12 00:00:00 | 17:05:22 | 2022-11-12 00:00:00 | 17:09:20 | 00:03:58 | -
2022-11-12 00:00:00 | 18:05:59 | 2022-11-12 00:00:00 | 18:38:49 | 00:32:50 | -
2022-11-12 00:00:00 | 18:54:06 | 2022-11-12 00:00:00 | 22:53:06 | 03:59:00 | -
2022-11-16 00:00:00 | 10:04:49 | 2022-11-16 00:00:00 | 12:26:57 | 02:22:08 | -
2022-11-16 00:00:00 | 12:35:50 | 2022-11-16 00:00:00 | 16:07:47 | 03:31:57 | -
2022-11-16 00:00:00 | 17:06:11 | 2022-11-16 00:00:00 | 21:59:39 | 04:53:28 | -
2022-11-17 00:00:00 | 09:57:32 | 2022-11-17 00:00:00 | 17:17:47 | 07:20:15 | -
2022-11-17 00:00:00 | 18:21:52 | 2022-11-17 00:00:00 | 22:01:22 | 03:39:30 | -
2022-11-18 00:00:00 | 14:51:48 | 2022-11-18 00:00:00 | 19:11:14 | 04:19:26 | -
2022-11-18 00:00:00 | 19:54:43 | 2022-11-18 00:00:00 | 22:50:33 | 02:55:50 | -
2022-11-19 00:00:00 | 09:57:00 | 2022-11-19 00:00:00 | 17:05:53 | 07:08:53 | -
2022-11-19 00:00:00 | 18:00:43 | 2022-11-19 00:00:00 | 22:32:52 | 04:32:09 | -
2022-11-21 00:00:00 | 10:02:41 | 2022-11-21 00:00:00 | 14:58:28 | 04:55:47 | -
2022-11-21 00:00:00 | 16:02:17 | 2022-11-21 00:00:00 | 18:59:00 | 02:56:43 | -
2022-11-21 00:00:00 | 19:07:32 | 2022-11-21 00:00:00 | 21:58:33 | 02:51:01 | -
2022-11-22 00:00:00 | 09:56:26 | 2022-11-22 00:00:00 | 12:55:08 | 02:58:42 | -
2022-11-22 00:00:00 | 12:59:01 | 2022-11-22 00:00:00 | 14:00:13 | 01:01:12 | -
2022-11-22 00:00:00 | 14:09:38 | 2022-11-22 00:00:00 | 15:35:33 | 01:25:55 | -
2022-11-22 00:00:00 | 16:34:39 | 2022-11-22 00:00:00 | 21:56:14 | 05:21:35 | -
2022-11-25 00:00:00 | 10:44:52 |  |  |  | -
 |  |  |  |  | Total Hours
 |  |  |  |  | staff name here
 |  |  |  |  | Hrs. Worked | unique formula | time worked that day |  |  | Dates | Total time worked
2022-10-26 00:00:00 | 15:01:08 |  | 22:15:00 |  | -
2022-10-27 00:00:00 | 15:03:30 | 2022-10-27 00:00:00 | 18:14:34 | 03:11:04 | - | 2022-10-27 00:00:00 | 06:09:17 |  |  | 2022-10-27 00:00:00 | 06:09:17
2022-10-27 00:00:00 | 18:47:22 | 2022-10-27 00:00:00 | 19:37:40 | 00:50:18 | - | 2022-10-29 00:00:00 | 12:15:29 |  |  | 2022-10-29 00:00:00 | 12:15:29
2022-10-27 00:00:00 | 20:00:37 | 2022-10-27 00:00:00 | 22:08:32 | 02:07:55 | - | 2022-10-31 00:00:00 | 06:37:48 |  |  | 2022-10-31 00:00:00 | 06:37:48
2022-10-29 00:00:00 | 09:00:24 | 2022-10-29 00:00:00 | 13:01:50 | 04:01:26 | - | 2022-11-01 00:00:00 | 06:35:25 |  |  | 2022-11-01 00:00:00 | 06:35:25
2022-10-29 00:00:00 | 13:15:02 | 2022-10-29 00:00:00 | 16:09:16 | 02:54:14 | - | 2022-11-04 00:00:00 | 09:47:04 |  |  | 2022-11-04 00:00:00 | 09:47:04
2022-10-29 00:00:00 | 17:02:42 | 2022-10-29 00:00:00 | 19:40:36 | 02:37:54 | - | 2022-11-05 00:00:00 | 09:32:16 |  |  | 2022-11-05 00:00:00 | 09:32:16
2022-10-29 00:00:00 | 19:59:13 | 2022-10-29 00:00:00 | 22:41:08 | 02:41:55 | - | 2022-11-06 00:00:00 | 09:00:59 |  |  | 2022-11-06 00:00:00 | 09:00:59
2022-10-31 00:00:00 | 14:54:26 | 2022-10-31 00:00:00 | 18:18:54 | 03:24:28 | - | 2022-11-08 00:00:00 | 06:26:02 |  |  | 2022-11-08 00:00:00 | 06:26:02
2022-10-31 00:00:00 | 18:48:22 | 2022-10-31 00:00:00 | 19:17:56 | 00:29:34 | - | 2022-11-09 00:00:00 | 06:35:36 |  |  | 2022-11-09 00:00:00 | 06:35:36
2022-10-31 00:00:00 | 19:33:53 | 2022-10-31 00:00:00 | 22:17:39 | 02:43:46 | - | 2022-11-10 00:00:00 | 06:38:01 |  |  | 2022-11-10 00:00:00 | 06:38:01
2022-11-01 00:00:00 | 15:00:29 | 2022-11-01 00:00:00 | 18:17:33 | 03:17:04 | - | 2022-11-11 00:00:00 | 12:31:06 |  |  | 2022-11-11 00:00:00 | 12:31:06
2022-11-01 00:00:00 | 18:50:23 | 2022-11-01 00:00:00 | 22:08:44 | 03:18:21 | -
2022-11-04 00:00:00 | 11:57:47 | 2022-11-04 00:00:00 | 14:31:40 | 02:33:53 | - | <<<here I have to copy paste the two formulas
2022-11-04 00:00:00 | 14:38:05 | 2022-11-04 00:00:00 | 16:25:08 | 01:47:03 | -
2022-11-04 00:00:00 | 16:34:32 | 2022-11-04 00:00:00 | 17:21:48 | 00:47:16 | -
2022-11-04 00:00:00 | 18:20:39 | 2022-11-04 00:00:00 | 22:59:31 | 04:38:52 | -
2022-11-05 00:00:00 | 11:59:20 | 2022-11-05 00:00:00 | 17:30:43 | 05:31:23 | -
2022-11-05 00:00:00 | 18:29:41 | 2022-11-05 00:00:00 | 22:30:34 | 04:00:53 | -
2022-11-06 00:00:00 | 12:01:07 | 2022-11-06 00:00:00 | 16:51:27 | 04:50:20 | -
2022-11-06 00:00:00 | 17:49:51 | 2022-11-06 00:00:00 | 22:00:30 | 04:10:39 | -
2022-11-08 00:00:00 | 14:57:46 | 2022-11-08 00:00:00 | 17:53:59 | 02:56:13 | -
2022-11-08 00:00:00 | 18:02:09 | 2022-11-08 00:00:00 | 18:07:13 | 00:05:04 | -
2022-11-08 00:00:00 | 18:37:28 | 2022-11-08 00:00:00 | 22:02:13 | 03:24:45 | -
2022-11-09 00:00:00 | 14:55:46 | 2022-11-09 00:00:00 | 18:09:48 | 03:14:02 | -
2022-11-09 00:00:00 | 18:40:50 | 2022-11-09 00:00:00 | 22:02:24 | 03:21:34 | -
2022-11-10 00:00:00 | 14:53:45 | 2022-11-10 00:00:00 | 18:09:08 | 03:15:23 | -
2022-11-10 00:00:00 | 18:15:54 | 2022-11-10 00:00:00 | 18:31:33 | 00:15:39 | -
2022-11-10 00:00:00 | 19:01:09 | 2022-11-10 00:00:00 | 22:08:08 | 03:06:59 | -
2022-11-11 00:00:00 | 08:58:18 | 2022-11-11 00:00:00 | 15:15:07 | 06:16:49 | -
2022-11-11 00:00:00 | 16:14:42 | 2022-11-11 00:00:00 | 19:55:53 | 03:41:11 | -
2022-11-11 00:00:00 | 20:10:41 | 2022-11-11 00:00:00 | 22:43:47 | 02:33:06 | -