Spreadsheet: 865659d1712683528-trying-to-reformat-time-punch-data-into-more-workable-format-nam-machine-sample-workbook
Sheet: Sheet1

Input |  |  |  |  |  |  |  |  |  |  |  | Output
WEEK | [NAME] | ESHEET
PAGE | 1 1 |  |  |  |  |  |  |  |  |  | Emp # | Name | Date | Clock In 1 | Clock Out 1 | Clock In 2 | Clock Out 2
CO#. | DEPT# | EMP#. | NAME........ | DATE.... | CLOCK-IN | CLOCK-OUT | HRS.. | REG... * O.T.. DT.... SICK. HOL.. VAC.. TRN.. OTH.. NP Over. BRK.... |  |  | 123 | [NAME] | 2022-01-04 00:00:00 | 06:54:00 | 11:57:00 | 12:55:00 | 17:45:00
 |  |  |  |  | TIMES | TIMES |  | RefOnly |  |  | 123 | [NAME] | 2022-01-05 00:00:00 | 06:53:00 | 11:57:00 | 12:49:00 | 17:50:00
 |  |  |  |  |  |  |  |  |  |  | 123 | [NAME] | 2022-01-07 00:00:00 | 07:00:00 | 11:57:00 | 12:57:00 | 17:52:00
1 | 3 | 123 | [NAME] | 2022-01-04 00:00:00 | 06:54:00 | 11:57:00 | 5.05 | 0 |  |  | 123 | [NAME] | 2022-01-08 00:00:00 | 06:54:00 | 11:59:00 | 12:56:00 | 17:51:00
 |  |  |  |  | 12:55:00 | 17:45:00 | 4.83 | 0 |  |  | 123 | [NAME] | 2022-01-09 00:00:00 | 06:53:00 | 11:59:00 | 12:55:00 | 17:42:00
 |  |  |  |  |  |  |  |  |  |  | 123 | [NAME] | 2022-01-13 00:00:00 | 06:56:00 | 12:01:00 | 12:57:00 | 17:51:00
1 | 3 | 123 | [NAME] | 2022-01-05 00:00:00 | 06:53:00 | 11:57:00 | 5.07 | 0
 |  |  |  |  | 12:49:00 | 17:50:00 | 5.02 | 0
1 | 3 | 123 | [NAME] | 2022-01-07 00:00:00 | 07:00:00 | 11:57:00 | 4.95 | 0
 |  |  |  |  | 12:57:00 | 17:52:00 | 4.92 | 0
1 | 3 | 123 | [NAME] | 2022-01-08 00:00:00 | 06:54:00 | 11:59:00 | 5.08 | 0
 |  |  |  |  | 12:56:00 | 17:51:00 | 4.92 | 0
1 | 3 | 123 | [NAME] | 2022-01-09 00:00:00 | 06:53:00 | 11:59:00 | 5.1 | 0
 |  |  |  |  | 12:55:00 | 17:42:00 | 4.78 | 0
1 | 3 | 123 | [NAME] | 2022-01-13 00:00:00 | 06:56:00 | 12:01:00 | 5.08 | 0
 |  |  |  |  | 12:57:00 | 17:51:00 | 4.9 | 0
WEEK | [NAME] | ESHEET
PAGE | 2 1
CO#. | DEPT# | EMP#. | NAME........ | DATE.... | CLOCK-IN | CLOCK-OUT | HRS.. | REG... * O.T.. DT.... SICK. HOL.. VAC.. TRN.. OTH.. NP Over. BRK....
 |  |  |  |  | TIMES | TIMES |  | RefOnly
1 | 3 | 123 | [NAME] | 2022-01-18 00:00:00 | 07:07:00 | 11:59:00 | 4.87 | 0
 |  |  |  |  | 12:55:00 | 17:55:00 | 5 | 0
1 | 3 | 123 | [NAME] | 2022-01-19 00:00:00 | 07:06:00 | 11:59:00 | 4.88 | 0
 |  |  |  |  | 12:57:00 | 17:52:00 | 4.92 | 0
1 | 3 | 123 | [NAME] | 2022-01-21 00:00:00 | 06:55:00 | 11:59:00 | 5.07 | 0
 |  |  |  |  | 12:53:00 | 17:43:00 | 4.83 | 0
1 | 3 | 123 | [NAME] | 2022-01-22 00:00:00 | 07:02:00 | 12:11:00 | 5.15 | 0
 |  |  |  |  | 13:13:00 | 17:52:00 | 4.65 | 0
1 | 3 | 123 | [NAME] | 2022-01-23 00:00:00 | 06:57:00 | 11:58:00 | 5.02 | 0
 |  |  |  |  | 12:56:00 | 17:27:00 | 4.52 | 0
1 | 3 | 123 | [NAME] | 2022-01-24 00:00:00 | 07:02:00 | 12:09:00 | 5.12 | 0
 |  |  |  |  | 13:06:00 | 17:42:00 | 4.6
WEEK | [NAME] | ESHEET
PAGE | 3 1
CO#. | DEPT# | EMP#. | NAME........ | DATE.... | CLOCK-IN | CLOCK-OUT | HRS.. | REG... * O.T.. DT.... SICK. HOL.. VAC.. TRN.. OTH.. NP Over. BRK....
 |  |  |  |  | TIMES | TIMES |  | RefOnly
1 | 3 | 124 | [NAME] | 2022-01-27 00:00:00 | 06:59:00 | 11:57:00 | 4.97 | 0
 |  |  |  |  | 12:58:00 | 17:55:00 | 4.95 | 0
1 | 3 | 124 | [NAME] | 2022-02-01 00:00:00 | 06:58:00 | 11:59:00 | 5.02 | 0
 |  |  |  |  | 12:52:00 | 17:51:00 | 4.98 | 0
1 | 3 | 124 | [NAME] | 2022-02-02 00:00:00 | 06:50:00 | 11:59:00 | 5.15 | 0
 |  |  |  |  | 12:51:00 | 17:55:00 | 5.07 | 0
1 | 3 | 124 | [NAME] | 2022-02-04 00:00:00 | 06:58:00 | 12:00:00 | 5.03 | 0
 |  |  |  |  | 12:57:00 | 17:46:00 | 4.82 | 0
1 | 3 | 124 | [NAME] | 2022-02-05 00:00:00 | 06:51:00 | 11:59:00 | 5.13 | 0
 |  |  |  |  | 12:55:00 | 17:47:00 | 4.87 | 0
WEEK | [NAME] | ESHEET
PAGE | 4 1
CO#. | DEPT# | EMP#. | NAME........ | DATE.... | CLOCK-IN | CLOCK-OUT | HRS.. | REG... * O.T.. DT.... SICK. HOL.. VAC.. TRN.. OTH.. NP Over. BRK....
 |  |  |  |  | TIMES | TIMES |  | RefOnly
1 | 3 | 126 | [NAME] | 2022-02-06 00:00:00 | 06:58:00 | 11:58:00 | 5 | 0
 |  |  |  |  | 12:59:00 | 17:46:00 | 4.78 | 0
1 | 3 | 126 | [NAME] | 2022-02-07 00:00:00 | 06:58:00 | 12:00:00 | 5.03 | 0
 |  |  |  |  | 12:54:00 | 17:48:00 | 4.9 | 0
1 | 3 | 126 | [NAME] | 2022-02-10 00:00:00 | 07:05:00 | 12:00:00 | 4.92 | 0
 |  |  |  |  | 12:58:00 | 17:59:00 | 5.02 | 0
1 | 3 | 126 | [NAME] | 2022-02-15 00:00:00 | 06:53:00 | 12:01:00 | 5.13 | 0
 |  |  |  |  | 12:56:00 | 17:53:00 | 4.95 | 0
1 | 3 | 126 | [NAME] | 2022-02-16 00:00:00 | 06:51:00 | 11:59:00 | 5.13 | 0
 |  |  |  |  | 12:54:00 | 17:52:00 | 4.97 | 0
1 | 3 | 126 | [NAME] | 2022-02-18 00:00:00 | 06:55:00 | 11:59:00 | 5.07 | 0
 |  |  |  |  | 12:56:00 | 17:56:00 | 5 | 0