Spreadsheet: 864126d1711440255-time-correction-only-data-aligw
Sheet: Sheet1

wo | TIME | QTY |  |  |  |  |  |  |  |  |  | expected result in column L
2547228 | 06:10:00 | 35 |  |  |  |  | TIME | QTY | TIME
2164485 | 06:10:00 | 47 |  |  |  | 2547228 | 06:10:00 | 35 | 06:10:00
2546405 | 06:15:00 | 35 |  |  |  | 2164485 | 06:10:00 | 47 | 06:10:00
2538885 | 06:15:00 | 47 |  |  |  | 2546405 | 06:15:00 | 35 | 06:15:00
2164463 | 06:15:00 | 48 |  |  |  | 2538885 | 06:15:00 | 47 | 06:15:00
2547228 | 06:20:00 | 36 |  |  |  | 2164463 | 06:15:00 | 48 | 06:15:00
2164479 | 06:20:00 | 47 |  |  |  | 2547228 | 06:20:00 | 36 | 06:20:00
2621367 | 06:20:00 | 59 |  |  |  | 2164479 | 06:20:00 | 47 | 06:20:00
2164485 | 06:20:00 | 48 |  |  |  | 2621367 | 06:20:00 | 59 | 06:20:00
2547039 | 06:25:00 | 47 |  |  |  | 2164485 | 06:20:00 | 48 | 06:20:00
2546405 | 06:25:00 | 36 |  |  |  | 2547039 | 06:25:00 | 47 | 06:25:00
2548434 | 06:25:00 | 47 |  |  |  | 2546405 | 06:25:00 | 36 | 06:25:00
2694950 | 06:30:00 | 47 |  |  |  | 2548434 | 06:25:00 | 47 | 06:25:00
2547228 | 06:30:00 | 36 |  |  |  | 2694950 | 06:30:00 | 47 | 06:30:00
2164528 | 22:35:00 | 48 |  |  |  | 2547228 | 06:30:00 | 36 | 06:30:00
2263857 | 22:35:00 | 48 |  |  |  | 2164528 | 22:35:00 | 48 | 22:35:00
2338257 | 22:40:00 | 48 |  |  |  | 2263857 | 22:35:00 | 48 | 22:35:00
2338269 | 22:42:00 | 48 |  |  |  | 2338257 | 22:40:00 | 48 | 22:40:00
2560714 | 22:45:00 | 48 |  |  |  | 2338269 | 22:42:00 | 48 | 22:42:00
2338934 | 22:45:00 | 36 |  |  |  | 2560714 | 22:45:00 | 48 | 22:45:00
2482847 | 22:45:00 | 36 |  |  |  | 2338934 | 22:45:00 | 36 | 22:45:00
2538909 | 22:45:00 | 48 |  |  |  | 2482847 | 22:45:00 | 36 | 22:45:00
2338257 | 22:50:00 | 48 |  |  |  | 2538909 | 22:45:00 | 48 | 22:45:00
2164550 | 22:50:00 | 48 |  |  |  | 2338257 | 22:50:00 | 48 | 22:50:00
2164528 | 22:50:00 | 48 |  |  |  | 2164550 | 22:50:00 | 48 | 22:50:00
2482847 | 22:50:00 | 36 |  |  |  | 2164528 | 22:50:00 | 48 | 22:50:00
2263857 | 22:50:00 | 48 |  |  |  | 2482847 | 22:50:00 | 36 | 22:50:00
2560714 | 23:00:00 | 48 |  |  |  | 2263857 | 22:50:00 | 48 | 22:50:00
2538909 | 23:00:00 | 48 |  |  |  | 2560714 | 23:00:00 | 48 | 23:00:00
2482847 | 23:00:00 | 36 |  |  |  | 2538909 | 23:00:00 | 48 | 23:00:00
2338934 | 01:00:00 | 36 |  |  |  | 2482847 | 23:00:00 | 36 | 23:00:00
2482847 | 01:00:00 | 36 |  |  |  | 2338934 | 01:00:00 | 36 | 1900-01-01 01:00:00
2547553 | 01:00:00 | 36 |  |  |  | 2482847 | 01:00:00 | 36 | 1900-01-01 01:00:00
2660448 | 01:00:00 | 48 |  |  |  | 2547553 | 01:00:00 | 36 | 1900-01-01 01:00:00
2164528 | 01:05:00 | 48 |  |  |  | 2660448 | 01:00:00 | 48 | 1900-01-01 01:00:00
2263857 | 01:09:00 | 48 |  |  |  | 2164528 | 01:05:00 | 48 | 1900-01-01 01:05:00
2660448 | 01:09:00 | 48 |  |  |  | 2263857 | 01:09:00 | 48 | 1900-01-01 01:09:00
2560714 | 01:10:00 | 48 |  |  |  | 2660448 | 01:09:00 | 48 | 1900-01-01 01:09:00
2338269 | 01:10:00 | 48 |  |  |  | 2560714 | 01:10:00 | 48 | 1900-01-01 01:10:00
2482847 | 01:10:00 | 36 |  |  |  | 2338269 | 01:10:00 | 48 | 1900-01-01 01:10:00
2547553 | 01:10:00 | 36 |  |  |  | 2482847 | 01:10:00 | 36 | 1900-01-01 01:10:00
2538869 | 01:10:00 | 48 |  |  |  | 2547553 | 01:10:00 | 36 | 1900-01-01 01:10:00
2338934 | 01:15:00 | 36 |  |  |  | 2538869 | 01:10:00 | 48 | 1900-01-01 01:10:00
2547003 | 01:15:00 | 36 |  |  |  | 2338934 | 01:15:00 | 36 | 1900-01-01 01:15:00
2660448 | 01:18:00 | 48 |  |  |  | 2547003 | 01:15:00 | 36 | 1900-01-01 01:15:00
2164528 | 01:20:00 | 48 |  |  |  | 2660448 | 01:18:00 | 48 | 1900-01-01 01:18:00
2482847 | 01:20:00 | 36 |  |  |  | 2164528 | 01:20:00 | 48 | 1900-01-01 01:20:00
2547553 | 01:20:00 | 36 |  |  |  | 2482847 | 01:20:00 | 36 | 1900-01-01 01:20:00
2263857 | 01:21:00 | 48 |  |  |  | 2547553 | 01:20:00 | 36 | 1900-01-01 01:20:00
2560714 | 01:23:00 | 48 |  |  |  | 2263857 | 01:21:00 | 48 | 1900-01-01 01:21:00
2538869 | 01:25:00 | 48 |  |  |  | 2560714 | 01:23:00 | 48 | 1900-01-01 01:23:00
2660448 | 01:26:00 | 48 |  |  |  | 2538869 | 01:25:00 | 48 | 1900-01-01 01:25:00
2338269 | 01:30:00 | 48 |  |  |  | 2660448 | 01:26:00 | 48 | 1900-01-01 01:26:00
2338934 | 01:30:00 | 36 |  |  |  | 2338269 | 01:30:00 | 48 | 1900-01-01 01:30:00
2482847 | 01:30:00 | 36 |  |  |  | 2338934 | 01:30:00 | 36 | 1900-01-01 01:30:00
2263857 | 01:32:00 | 48 |  |  |  | 2482847 | 01:30:00 | 36 | 1900-01-01 01:30:00
2164528 | 01:35:00 | 48 |  |  |  | 2263857 | 01:32:00 | 48 | 1900-01-01 01:32:00
2560714 | 01:35:00 | 48 |  |  |  | 2164528 | 01:35:00 | 48 | 1900-01-01 01:35:00
2547003 | 01:35:00 | 36 |  |  |  | 2560714 | 01:35:00 | 48 | 1900-01-01 01:35:00
2660448 | 01:35:00 | 48 |  |  |  | 2547003 | 01:35:00 | 36 | 1900-01-01 01:35:00
2538869 | 01:37:00 | 48 |  |  |  | 2660448 | 01:35:00 | 48 | 1900-01-01 01:35:00
2547553 | 01:38:00 | 36 |  |  |  | 2538869 | 01:37:00 | 48 | 1900-01-01 01:37:00
2482847 | 01:40:00 | 36 |  |  |  | 2547553 | 01:38:00 | 36 | 1900-01-01 01:38:00
2263857 | 01:44:00 | 48 |  |  |  | 2482847 | 01:40:00 | 36 | 1900-01-01 01:40:00
2660448 | 01:44:00 | 48 |  |  |  | 2263857 | 01:44:00 | 48 | 1900-01-01 01:44:00
2482847 | 01:45:00 | 36 |  |  |  | 2660448 | 01:44:00 | 48 | 1900-01-01 01:44:00
2164528 | 01:50:00 | 48 |  |  |  | 2482847 | 01:45:00 | 36 | 1900-01-01 01:45:00
2560714 | 01:50:00 | 48 |  |  |  | 2164528 | 01:50:00 | 48 | 1900-01-01 01:50:00
2482847 | 01:50:00 | 36 |  |  |  | 2560714 | 01:50:00 | 48 | 1900-01-01 01:50:00
2547553 | 01:50:00 | 18 |  |  |  | 2482847 | 01:50:00 | 36 | 1900-01-01 01:50:00
2538869 | 01:50:00 | 48 |  |  |  | 2547553 | 01:50:00 | 18 | 1900-01-01 01:50:00
2660448 | 01:51:00 | 48 |  |  |  | 2538869 | 01:50:00 | 48 | 1900-01-01 01:50:00
2338269 | 01:53:00 | 48 |  |  |  | 2660448 | 01:51:00 | 48 | 1900-01-01 01:51:00
2547003 | 01:55:00 | 36 |  |  |  | 2338269 | 01:53:00 | 48 | 1900-01-01 01:53:00
2164528 | 02:00:00 | 48 |  |  |  | 2547003 | 01:55:00 | 36 | 1900-01-01 01:55:00
2338934 | 02:00:00 | 36 |  |  |  | 2164528 | 02:00:00 | 48 | 1900-01-01 02:00:00
2482847 | 02:00:00 | 36 |  |  |  | 2338934 | 02:00:00 | 36 | 1900-01-01 02:00:00
2538869 | 02:00:00 | 48 |  |  |  | 2482847 | 02:00:00 | 36 | 1900-01-01 02:00:00
2660448 | 02:00:00 | 48 |  |  |  | 2538869 | 02:00:00 | 48 | 1900-01-01 02:00:00
2263857 | 02:01:00 | 48 |  |  |  | 2660448 | 02:00:00 | 48 | 1900-01-01 02:00:00
 |  |  |  |  |  | 2263857 | 02:01:00 | 48 | 1900-01-01 02:01:00