Spreadsheet: 767726d1644595323-time-between-steps-while-referencing-part-work-order-excel-question
Sheet: Sheet1

Part_Work_Order | Date_Created | Current Cell | Current Step | Previous Step | Step_Complete_Date_Time | Route_Step_Num | Cell | Time differnce From last set
12576W | 2022-02-03 16:51:41 | FINSAWS | 7 | 6 | 2022-02-04 06:32:25 | 7 | LAYOUT
12576W | 2022-02-03 16:51:41 | FINSAWS | 7 | 6 | 2022-02-05 07:43:22 | 5 | WAX
12576W | 2022-02-03 16:51:41 | FINSAWS | 7 | 6 | 2022-02-06 02:30:39 | 3 | COREDRILL
12576W | 2022-02-03 16:51:41 | FINSAWS | 7 | 6 | 2022-02-06 11:24:00 | 4 | WAX
12576W | 2022-02-03 16:51:41 | FINSAWS | 7 | 6 | 2022-02-06 11:24:03 | 2 | 120
12576W | 2022-02-03 16:51:41 | FINSAWS | 7 | 6 |  | 8 | FINSAWS
12576W | 2022-02-03 16:51:41 | FINSAWS | 7 | 6 |  | 9 | WOCLOSE
12576V | 2022-02-03 16:51:41 | WOCLOSE | 9 | 8 | 2022-02-04 06:23:29 | 2 | LAYOUT
12576V | 2022-02-03 16:51:41 | WOCLOSE | 9 | 8 | 2022-02-05 07:43:31 | 3 | WAX
12576V | 2022-02-03 16:51:41 | WOCLOSE | 9 | 8 | 2022-02-06 02:30:24 | 4 | COREDRILL
12576V | 2022-02-03 16:51:41 | WOCLOSE | 9 | 8 | 2022-02-06 11:23:22 | 5 | WAX
12576V | 2022-02-03 16:51:41 | WOCLOSE | 9 | 8 | 2022-02-06 11:23:25 | 6 | 120
12576V | 2022-02-03 16:51:41 | WOCLOSE | 9 | 8 | 2022-02-09 14:46:56 | 7 | FINSAWS
12576V | 2022-02-03 16:51:41 | WOCLOSE | 9 | 8 |  | 9 | WOCLOSE
12576T | 2022-02-03 16:51:41 | FINSAWS | 7 | 6 | 2022-02-04 06:15:09 | 1 | LAYOUT
12576T | 2022-02-03 16:51:41 | FINSAWS | 7 | 6 | 2022-02-05 07:43:50 | 2 | WAX
12576T | 2022-02-03 16:51:41 | FINSAWS | 7 | 6 | 2022-02-06 02:29:50 | 3 | COREDRILL
12576T | 2022-02-03 16:51:41 | FINSAWS | 7 | 6 | 2022-02-06 11:22:46 | 4 | WAX
12576T | 2022-02-03 16:51:41 | FINSAWS | 7 | 6 | 2022-02-06 11:22:49 | 5 | 120
12576T | 2022-02-03 16:51:41 | FINSAWS | 7 | 6 |  | 7 | FINSAWS
12576T | 2022-02-03 16:51:41 | FINSAWS | 7 | 6 |  | 9 | WOCLOSE
12576U | 2022-02-03 16:51:41 | FINSAWS | 7 | 6 | 2022-02-04 06:18:02 | 8 | LAYOUT
12576U | 2022-02-03 16:51:41 | FINSAWS | 7 | 6 | 2022-02-05 07:43:40 | 6 | WAX
12576U | 2022-02-03 16:51:41 | FINSAWS | 7 | 6 | 2022-02-06 02:30:09 | 4 | COREDRILL
12576U | 2022-02-03 16:51:41 | FINSAWS | 7 | 6 | 2022-02-06 11:23:05 | 5 | WAX
12576U | 2022-02-03 16:51:41 | FINSAWS | 7 | 6 | 2022-02-06 11:23:08 | 3 | 120
12576U | 2022-02-03 16:51:41 | FINSAWS | 7 | 6 |  | 10 | FINSAWS
12576U | 2022-02-03 16:51:41 | FINSAWS | 7 | 6 |  | 9 | WOCLOSE
12576F | 2022-02-03 16:51:40 | FINSAWS | 7 | 6 | 2022-02-03 17:21:13 | 1 | LAYOUT
12576F | 2022-02-03 16:51:40 | FINSAWS | 7 | 6 | 2022-02-05 07:42:34 | 2 | WAX
12576F | 2022-02-03 16:51:40 | FINSAWS | 7 | 6 | 2022-02-06 02:32:06 | 3 | COREDRILL
12576F | 2022-02-03 16:51:40 | FINSAWS | 7 | 6 | 2022-02-06 11:25:30 | 4 | WAX
12576F | 2022-02-03 16:51:40 | FINSAWS | 7 | 6 | 2022-02-06 11:25:33 | 5 | 120
12576F | 2022-02-03 16:51:40 | FINSAWS | 7 | 6 |  | 7 | FINSAWS
12576F | 2022-02-03 16:51:40 | FINSAWS | 7 | 6 |  | 9 | WOCLOSE
12576G | 2022-02-03 16:51:40 | FINSAWS | 7 | 6 | 2022-02-03 17:23:31 | 1 | LAYOUT
12576G | 2022-02-03 16:51:40 | FINSAWS | 7 | 6 | 2022-02-05 07:42:24 | 2 | WAX
12576G | 2022-02-03 16:51:40 | FINSAWS | 7 | 6 | 2022-02-06 02:32:38 | 3 | COREDRILL
12576J | 2022-02-03 16:51:40 | GANGWS | 7 | 6 | 2022-02-04 06:34:32 | 1 | LAYOUT
12576J | 2022-02-03 16:51:40 | GANGWS | 7 | 6 | 2022-02-05 07:41:25 | 2 | WAX
12576J | 2022-02-03 16:51:40 | GANGWS | 7 | 6 | 2022-02-06 02:34:15 | 3 | COREDRILL
12576J | 2022-02-03 16:51:40 | GANGWS | 7 | 6 | 2022-02-06 11:27:12 | 4 | WAX
12576J | 2022-02-03 16:51:40 | GANGWS | 7 | 6 | 2022-02-06 11:27:15 | 5 | 120
12576J | 2022-02-03 16:51:40 | GANGWS | 7 | 6 |  | 7 | FINSAWS
12576J | 2022-02-03 16:51:40 | GANGWS | 7 | 6 |  | 8 | FINSAWS
12576J | 2022-02-03 16:51:40 | GANGWS | 7 | 6 |  | 10 | WOCLOSE