Spreadsheet: 834712d1688027245-group-values-based-on-time-slot-and-week-day-sampled-work
Sheet: INPUT

SUNDAY |  | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THRUDAY |  | FRIDAY |  | SATURDAY
NUMBER | TIME | NUMBER | TIME | NUMBER | TIME | NUMBER | TIME | NUMBER | TIME | NUMBER | TIME | NUMBER | TIME
22153 | 06:10:00 | 22153 | 06:10:00 | 22153 | 06:10:00 | 22153 | 06:10:00 | 22153 | 06:10:00 | 22153 | 06:10:00 | 22153 | 06:10:00
22154 | 00:00:00 | 22154 | 00:00:00 | 22154 | 00:00:00 | 22154 | 00:00:00 | 22154 | 00:00:00 | 22154 | 00:00:00 | 22154 | 00:00:00
20644 | 07:58:00 | 12257 | 01:10:00 | 20644 | 07:58:00 | 12257 | 01:10:00 | 20644 | 07:58:00 | 12257 | 01:10:00 | 20644 | 07:58:00
12243 | 11:28:00 | 20644 | 07:58:00 | 20643 | 17:48:00 | 3358 | 03:28:00 | 12243 | 11:28:00 | 20644 | 07:58:00 | 12243 | 11:28:00
12244 | 17:23:00 | 12243 | 11:28:00 | 22207 | 20:33:00 | 12243 | 11:28:00 | 12244 | 17:23:00 | 12243 | 11:28:00 | 12244 | 17:23:00
20643 | 17:48:00 | 12244 | 17:23:00 | 22643 | 00:02:00 | 12244 | 17:23:00 | 20643 | 17:48:00 | 12244 | 17:23:00 | 20643 | 17:48:00
16320 | 22:38:00 | 20643 | 17:48:00 | 22640 | 00:12:00 | 6042 | 21:33:00 | 22640 | 00:12:00 | 20643 | 17:48:00 | 22640 | 00:12:00
22640 | 00:12:00 | 12515 | 00:02:00 | 12623 | 00:12:00 | 22643 | 00:02:00 | 12623 | 00:12:00 | 22207 | 20:33:00 | 12623 | 00:12:00
12623 | 00:12:00 | 22640 | 00:12:00 | 16231 | 00:17:00 | 22640 | 00:12:00 | 16231 | 00:17:00 | 16320 | 22:38:00 | 16231 | 00:17:00
16231 | 00:17:00 | 12623 | 00:12:00 | 16526 | 00:22:00 | 12623 | 00:12:00 | 16526 | 00:22:00 | 22640 | 00:12:00 | 16526 | 00:22:00
16526 | 00:22:00 | 16231 | 00:17:00 | 16527 | 00:32:00 | 16231 | 00:17:00 | 16527 | 00:32:00 | 12623 | 00:12:00 | 16527 | 00:32:00
16527 | 00:32:00 | 16526 | 00:22:00 | 12602 | 00:37:00 | 16526 | 00:22:00 | 12602 | 00:37:00 | 16231 | 00:17:00 | 12602 | 00:37:00
12602 | 00:37:00 | 16527 | 00:32:00 | 12672 | 00:52:00 | 16527 | 00:32:00 | 12672 | 00:52:00 | 16526 | 00:22:00 | 12672 | 00:52:00
12672 | 00:52:00 | 12602 | 00:37:00 | 12601 | 00:57:00 | 12602 | 00:37:00 | 12601 | 00:57:00 | 16527 | 00:32:00 | 12601 | 00:57:00
12601 | 00:57:00 | 12672 | 00:52:00 | 12674 | 01:07:00 | 12672 | 00:52:00 | 12674 | 01:07:00 | 18567 | 00:37:00 | 12674 | 01:07:00
12674 | 01:07:00 | 12601 | 00:57:00 | 16235 | 01:07:00 | 12601 | 00:57:00 | 16235 | 01:07:00 | 12602 | 00:37:00 | 16235 | 01:07:00
16235 | 01:07:00 | 12674 | 01:07:00 | 16525 | 01:27:00 | 12674 | 01:07:00 | 16525 | 01:27:00 | 12672 | 00:52:00 | 16525 | 01:27:00
16525 | 01:27:00 | 16235 | 01:07:00 | 22639 | 01:32:00 | 16235 | 01:07:00 | 22639 | 01:32:00 | 12601 | 00:57:00 | 22639 | 01:32:00
22639 | 01:32:00 | 16525 | 01:27:00 | 16528 | 01:37:00 | 22837 | 01:22:00 | 16528 | 01:37:00 | 12674 | 01:07:00 | 16528 | 01:37:00
16528 | 01:37:00 | 22639 | 01:32:00 | 12671 | 01:47:00 | 16525 | 01:27:00 | 12671 | 01:47:00 | 16235 | 01:07:00 | 12671 | 01:47:00
12671 | 01:47:00 | 16528 | 01:37:00 | 16236 | 02:02:00 | 22639 | 01:32:00 | 16236 | 02:02:00 | 16525 | 01:27:00 | 12682 | 01:47:00
12645 | 01:47:00 | 12671 | 01:47:00 | 12624 | 02:12:00 | 16528 | 01:37:00 | 12624 | 02:12:00 | 22639 | 01:32:00 | 16236 | 02:02:00
16236 | 02:02:00 | 16236 | 02:02:00 | 12686 | 02:37:00 | 12643 | 01:47:00 | 12686 | 02:37:00 | 16528 | 01:37:00 | 12624 | 02:12:00
12624 | 02:12:00 | 12624 | 02:12:00 | 12673 | 02:47:00 | 12671 | 01:47:00 | 12673 | 02:47:00 | 12671 | 01:47:00 | 12686 | 02:37:00
12686 | 02:37:00 | 12686 | 02:37:00 | 16316 | 03:32:00 | 16236 | 02:02:00 | 16316 | 03:32:00 | 16236 | 02:02:00 | 12673 | 02:47:00
12673 | 02:47:00 | 12673 | 02:47:00 | 11013 | 03:37:00 | 12624 | 02:12:00 | 11013 | 03:37:00 | 12624 | 02:12:00 | 16316 | 03:32:00
12681 | 03:17:00 | 16316 | 03:32:00 | 12511 | 03:52:00 | 12686 | 02:37:00 | 12521 | 03:52:00 | 12686 | 02:37:00 | 11013 | 03:37:00
16316 | 03:32:00 | 11013 | 03:37:00 | 17315 | 04:02:00 | 12673 | 02:47:00 | 12687 | 04:02:00 | 16614 | 02:37:00 | 12511 | 03:52:00
11013 | 03:37:00 | 22647 | 03:52:00 | 16787 | 04:02:00 | 16316 | 03:32:00 | 22649 | 04:12:00 | 12673 | 02:47:00 | 16317 | 04:02:00
12511 | 03:52:00 | 12659 | 03:52:00 | 22649 | 04:12:00 | 11013 | 03:37:00 | 12258 | 04:12:00 | 12648 | 03:17:00 | 22649 | 04:12:00
22649 | 04:12:00 | 12687 | 04:02:00 | 12258 | 04:12:00 | 22645 | 03:52:00 | 12696 | 04:37:00 | 16316 | 03:32:00 | 12258 | 04:12:00
22641 | 04:12:00 | 22649 | 04:12:00 | 12696 | 04:37:00 | 12507 | 04:12:00 | 17230 | 04:52:00 | 11013 | 03:37:00 | 12696 | 04:37:00
12696 | 04:37:00 | 12696 | 04:37:00 | 17230 | 04:52:00 | 22649 | 04:12:00 | 22208 | 05:09:00 | 22647 | 03:52:00 | 17230 | 04:52:00
17230 | 04:52:00 | 17230 | 04:52:00 | 13351 | 05:22:00 | 12696 | 04:37:00 | 13351 | 05:22:00 | 22649 | 04:12:00 | 13351 | 05:22:00
12698 | 04:57:00 | 22208 | 05:09:00 | 16566 | 06:32:00 | 17230 | 04:52:00 | 22838 | 06:12:00 | 22641 | 04:12:00 | 18568 | 06:12:00
16319 | 05:07:00 | 16565 | 05:12:00 | 22503 | 06:52:00 | 6083 | 05:07:00 | 12790 | 06:32:00 | 12696 | 04:37:00 | 22644 | 07:37:00
13351 | 05:22:00 | 13351 | 05:22:00 | 22642 | 07:37:00 | 13351 | 05:22:00 | 22503 | 06:52:00 | 17230 | 04:52:00 | 22666 | 08:07:00
7190 | 06:12:00 | 22503 | 06:52:00 | 22504 | 07:52:00 | 17316 | 07:22:00 | 6044 | 06:52:00 | 16319 | 05:07:00 | 12680 | 08:32:00
12790 | 06:32:00 | 19567 | 07:22:00 | 22666 | 08:07:00 | 22504 | 07:52:00 | 22642 | 07:37:00 | 13351 | 05:22:00 | 12626 | 09:42:00
22503 | 06:52:00 | 22666 | 08:07:00 | 22616 | 08:22:00 | 12680 | 08:32:00 | 16318 | 08:07:00 | 22503 | 06:52:00 | 12677 | 10:02:00
22669 | 07:22:00 | 12680 | 08:32:00 | 12680 | 08:32:00 | 12688 | 08:47:00 | 22666 | 08:07:00 | 12660 | 07:07:00 | 22638 | 10:12:00
22644 | 07:37:00 | 12626 | 09:42:00 | 12626 | 09:42:00 | 12626 | 09:42:00 | 22616 | 08:22:00 | 22504 | 07:52:00 | 12675 | 11:07:00
22504 | 07:52:00 | 12677 | 10:02:00 | 12677 | 10:02:00 | 12677 | 10:02:00 | 12680 | 08:32:00 | 22666 | 08:07:00 | 7189 | 12:47:00
22666 | 08:07:00 | 22638 | 10:12:00 | 22638 | 10:12:00 | 22638 | 10:12:00 | 12626 | 09:42:00 | 22616 | 08:22:00 | 13352 | 14:57:00
16788 | 08:07:00 | 12675 | 11:07:00 | 12675 | 11:07:00 | 12675 | 11:07:00 | 12677 | 10:02:00 | 12516 | 08:27:00 | 12678 | 15:32:00
22616 | 08:22:00 | 13352 | 14:57:00 | 22815 | 12:47:00 | 22619 | 12:47:00 | 22638 | 10:12:00 | 12680 | 08:32:00 | 16332 | 16:07:00
12508 | 08:27:00 | 12678 | 15:32:00 | 13352 | 14:57:00 | 18190 | 14:47:00 | 12675 | 11:07:00 | 12626 | 09:42:00 | 19568 | 16:57:00
12680 | 08:32:00 | 16613 | 16:57:00 | 12678 | 15:32:00 | 13352 | 14:57:00 | 12970 | 13:37:00 | 12677 | 10:02:00 | 12676 | 17:42:00
12688 | 08:47:00 | 12676 | 17:42:00 | 12676 | 17:42:00 | 12678 | 15:32:00 | 22670 | 14:02:00 | 22638 | 10:12:00 | 22665 | 17:52:00
22852 | 09:02:00 | 22665 | 17:52:00 | 22665 | 17:52:00 | 22816 | 16:07:00 | 13352 | 14:57:00 | 12675 | 11:07:00 | 22646 | 18:02:00
12626 | 09:42:00 | 22648 | 18:02:00 | 12512 | 18:02:00 | 6084 | 16:57:00 | 12678 | 15:32:00 | 12969 | 11:47:00 | 22637 | 18:32:00
12677 | 10:02:00 | 22637 | 18:32:00 | 22637 | 18:32:00 | 12676 | 17:42:00 | 12676 | 17:42:00 | 8312 | 14:47:00 | 12679 | 19:12:00
22638 | 10:12:00 | 18189 | 18:42:00 | 12679 | 19:12:00 | 12512 | 18:02:00 | 22665 | 17:52:00 | 13352 | 14:57:00 | 17229 | 19:12:00
12675 | 11:07:00 | 12679 | 19:12:00 | 17229 | 19:12:00 | 22637 | 18:32:00 | 22648 | 18:02:00 | 12678 | 15:32:00 | 12644 | 19:22:00
18190 | 14:47:00 | 17229 | 19:12:00 | 6041 | 19:22:00 | 12679 | 19:12:00 | 22637 | 18:32:00 | 12676 | 17:42:00 | 22615 | 19:37:00
13352 | 14:57:00 | 22615 | 19:37:00 | 12695 | 20:07:00 | 17229 | 19:12:00 | 8311 | 18:42:00 | 22665 | 17:52:00 | 12695 | 20:07:00
12678 | 15:32:00 | 16331 | 19:47:00 | 16381 | 21:02:00 | 12646 | 19:22:00 | 12679 | 19:12:00 | 12522 | 18:02:00 | 16381 | 21:02:00
22620 | 16:07:00 | 12695 | 20:07:00 | 12685 | 21:12:00 | 22615 | 19:37:00 | 17229 | 19:12:00 | 22637 | 18:32:00 | 12685 | 21:12:00
12676 | 17:42:00 | 16381 | 21:02:00 | 16315 | 21:17:00 | 12777 | 19:47:00 | 6043 | 19:22:00 | 18189 | 18:42:00 | 16315 | 21:17:00
22665 | 17:52:00 | 12685 | 21:12:00 | 22650 | 21:57:00 | 12695 | 20:07:00 | 22615 | 19:37:00 | 12679 | 19:12:00 | 22650 | 21:57:00
12512 | 18:02:00 | 16315 | 21:17:00 | 12789 | 22:12:00 | 16381 | 21:02:00 | 22677 | 19:47:00 | 17229 | 19:12:00 | 17615 | 22:27:00
22637 | 18:32:00 | 22650 | 21:57:00 | 12684 | 22:37:00 | 12685 | 21:12:00 | 12695 | 20:07:00 | 12695 | 20:07:00 | 16382 | 22:47:00
12647 | 18:47:00 | 12684 | 22:37:00 | 16382 | 22:47:00 | 16315 | 21:17:00 | 16381 | 21:02:00 | 16381 | 21:02:00 | 12625 | 23:32:00
12679 | 19:12:00 | 16382 | 22:47:00 | 12625 | 23:32:00 | 22650 | 21:57:00 | 12685 | 21:12:00 | 12685 | 21:12:00 | 16232 | 23:42:00
17229 | 19:12:00 | 22608 | 23:07:00 | 16232 | 23:42:00 | 16382 | 22:47:00 | 16315 | 21:17:00 | 16315 | 21:17:00 | 16573 | 01:15:00
12697 | 19:47:00 | 12683 | 23:22:00 | 3357 | 00:30:00 | 12683 | 23:22:00 | 22650 | 21:57:00 | 22851 | 21:27:00 | 22651 | 02:35:00
17616 | 19:52:00 | 12625 | 23:32:00 | 22651 | 02:35:00 | 12625 | 23:32:00 | 12684 | 22:37:00 | 22650 | 21:57:00 | 20601 | 03:00:00
12695 | 20:07:00 | 16232 | 23:42:00 | 20601 | 03:00:00 | 16232 | 23:42:00 | 16382 | 22:47:00 | 12789 | 22:12:00 | 17236 | 03:50:00
16381 | 21:02:00 | 20602 | 02:15:00 | 17236 | 03:50:00 | 20602 | 02:15:00 | 12778 | 23:22:00 | 16382 | 22:47:00 | 16733 | 06:00:00
12685 | 21:12:00 | 22651 | 02:35:00 | 7325 | 09:25:00 | 22651 | 02:35:00 | 12625 | 23:32:00 | 12625 | 23:32:00 | 11014 | 11:20:00
16315 | 21:17:00 | 17236 | 03:50:00 | 11014 | 11:20:00 | 17236 | 03:50:00 | 16232 | 23:42:00 | 16232 | 23:42:00 | 6547 | 11:50:00
22650 | 21:57:00 | 7356 | 05:45:00 | 16340 | 15:45:00 | 11014 | 11:20:00 | 22651 | 02:35:00 | 22678 | 23:42:00 | 16354 | 18:55:00
16382 | 22:47:00 | 12690 | 06:15:00 | 17235 | 22:15:00 | 16340 | 15:45:00 | 20601 | 03:00:00 | 20602 | 02:15:00 | 7355 | 19:50:00
12683 | 23:22:00 | 16353 | 08:30:00 | 22652 | 22:35:00 | 22497 | 18:50:00 | 17236 | 03:50:00 | 22651 | 02:35:00 | 17235 | 22:15:00
22607 | 23:22:00 | 11014 | 11:20:00 | 7326 | 23:45:00 | 17235 | 22:15:00 | 11014 | 11:20:00 | 17236 | 03:50:00 | 22652 | 22:35:00
12625 | 23:32:00 | 16340 | 15:45:00 |  |  | 22652 | 22:35:00 | 16734 | 11:25:00 | 22498 | 07:15:00 | 16856 | 03:50:00
16232 | 23:42:00 | 17235 | 22:15:00 |  |  | 16339 | 22:40:00 | 17235 | 22:15:00 | 11014 | 11:20:00
22651 | 02:35:00 | 22652 | 22:35:00 |  |  |  |  | 22652 | 22:35:00 | 16340 | 15:45:00
16574 | 03:00:00 | 11021 | 03:20:00 |  |  |  |  | 16339 | 22:40:00 | 17235 | 22:15:00
17236 | 03:50:00 | 11022 | 22:05:00 |  |  |  |  | 11021 | 03:20:00 | 22652 | 22:35:00
6548 | 06:10:00 |  |  |  |  |  |  | 11022 | 22:05:00 | 16339 | 22:40:00
11014 | 11:20:00 |  |  |  |  |  |  | 16855 | 22:05:00 | 12689 | 23:50:00
17235 | 22:15:00 |  |  |  |  |  |  |  |  | 11021 | 03:20:00
22652 | 22:35:00 |  |  |  |  |  |  |  |  | 11022 | 22:05:00
16339 | 22:40:00