Spreadsheet: 767866d1644683368-time-between-steps-while-referencing-part-work-order-excel-question
Sheet: Sheet2

Part_Work_Order | Date_Created | Current Cell | Current Step | Previous Step | Step_Complete_Date_Time | Route_Step_Num | Cell | Time differnce From last set |  | Values wanted:
51128FC1 | 2022-01-25 10:21:46 | FINALINSP | 5 | 4 | 2022-01-27 17:35:16 | 2 | COREDRILL |  |  |  |  |  | The highlighted cells are a perfect example of the Route_Step_Num not being in order.
51128FC1 | 2022-01-25 10:21:46 | FINALINSP | 5 | 4 |  | 5 | FINALINSP
51128FC1 | 2022-01-25 10:21:46 | FINALINSP | 5 | 4 | 2022-01-25 10:21:50 | 1 | LAYOUT
73039DL24 | 2022-01-25 10:13:30 | LAYOUT | 13 | 12 | 2022-01-25 10:13:44 | 2 | ULELO |  |  |  |  |  | Notice the first route-Step_Num in this case is not 1.
73039DL24 | 2022-01-25 10:13:30 | LAYOUT | 13 | 12 | 2022-01-26 06:49:01 | 3 | MIRROR
73039DL24 | 2022-01-25 10:13:30 | LAYOUT | 13 | 12 | 2022-01-31 07:16:42 | 4 | LAYOUT
73039DL24 | 2022-01-25 10:13:30 | LAYOUT | 13 | 12 | 2022-01-31 07:16:48 | 6 | LAYOUT
73039DL24 | 2022-01-25 10:13:30 | LAYOUT | 13 | 12 | 2022-02-02 09:30:07 | 8 | TILESAW
73039DL24 | 2022-01-25 10:13:30 | LAYOUT | 13 | 12 | 2022-02-02 09:30:11 | 9 | 120
73039DL24 | 2022-01-25 10:13:30 | LAYOUT | 13 | 12 | 2022-02-02 09:30:15 | 11 | 320
73039DL24 | 2022-01-25 10:13:30 | LAYOUT | 13 | 12 | 2022-02-02 09:30:19 | 12 | TILESAW
73039DL24 | 2022-01-25 10:13:30 | LAYOUT | 13 | 12 |  | 13 | LAYOUT |  |  |  | Because step 13 is the next step and has no time it should be the time now - the time of the last Step.
73039DL24 | 2022-01-25 10:13:30 | LAYOUT | 13 | 12 |  | 14 | LAYOUT |  |  | 0
91113G2R | 2022-01-25 09:49:28 | FINALINSP | 7 | 6 | 2022-01-25 09:50:11 | 1 | FINSAWS
91113G2R | 2022-01-25 09:49:28 | FINALINSP | 7 | 6 | 2022-01-25 22:41:36 | 3 | 120
91113G2R | 2022-01-25 09:49:28 | FINALINSP | 7 | 6 | 2022-01-25 23:10:30 | 4 | 320
91113G2R | 2022-01-25 09:49:28 | FINALINSP | 7 | 6 | 2022-01-25 23:10:33 | 5 | 120
91113G2R | 2022-01-25 09:49:28 | FINALINSP | 7 | 6 | 2022-01-31 23:25:56 | 6 | HUFFMAN
91113G2R | 2022-01-25 09:49:28 | FINALINSP | 7 | 6 |  | 7 | FINALINSP
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 | 2022-02-03 01:18:53 | 2 | FIN5AWJ
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 | 2022-02-03 06:48:39 | 4 | ACID1
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 | 2022-02-07 19:36:07 | 5 | BIREFRINGE
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 | 2022-02-07 19:55:24 | 6 | BIREFRINGE
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 | 2022-02-08 08:10:13 | 7 | LAYOUT_BR
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 |  | 8 | 120
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 |  | 9 | 320 |  |  | 0 | step 9 through 21 should all be 0 because the part is not waiting there. It I s waiting at step 8 because a time was not put in there.
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 | 2022-01-25 08:52:34 | 1 | LAYOUT
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 |  | 10 | ACID1 |  |  | 0 | step 9 through 21 should all be 0 because the part is not waiting there. It I s waiting at step 8 because a time was not put in there.
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 |  | 11 | H2_LOAD |  |  | 0 | step 9 through 21 should all be 0 because the part is not waiting there. It I s waiting at step 8 because a time was not put in there.
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 |  | 12 | LOREVIEW_C |  |  | 0 | step 9 through 21 should all be 0 because the part is not waiting there. It I s waiting at step 8 because a time was not put in there.
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 |  | 13 | HUFFMAN |  |  | 0 | step 9 through 21 should all be 0 because the part is not waiting there. It I s waiting at step 8 because a time was not put in there.
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 |  | 15 | RAMAN |  |  | 0 | step 9 through 21 should all be 0 because the part is not waiting there. It I s waiting at step 8 because a time was not put in there.
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 |  | 16 | IP_FI |  |  | 0 | step 9 through 21 should all be 0 because the part is not waiting there. It I s waiting at step 8 because a time was not put in there.
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 |  | 17 | [NAME] |  |  | 0 | step 9 through 21 should all be 0 because the part is not waiting there. It I s waiting at step 8 because a time was not put in there.
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 |  | 18 | FINALINSP |  |  | 0 | step 9 through 21 should all be 0 because the part is not waiting there. It I s waiting at step 8 because a time was not put in there.
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 |  | 20 | SETASMBLY |  |  | 0 | step 9 through 21 should all be 0 because the part is not waiting there. It I s waiting at step 8 because a time was not put in there.
12778A1CF | 2022-01-25 08:51:52 | 120 | 8 | 7 |  | 21 | SETASMBLY