Forum Discussion
Calculating Time Between Start of One operation and End of the previous operations
I am trying to achieve this task using excel Power Query. I am trying to do a transformation on a data set that has Work Orders. So there are multiple Routing IDs. With each Routing ID there are on...
If I understood your question, you may follow these steps...
- You can create a Reference of the existing query.
- Then insert an Index column starting from 1 in the original query.
- Insert an Index column starting from 0 in the Referenced query.
- Then merge both the queries on Index Columns and extract the Start Time Field from the reference query.
- Now in the merged query you will have start time for one operation and start time of the next operation in the same row and you may then add a new column subtracting both the times.
- Dear Subodh
Thank you so much! I will test this solution and will update you shortly. 🙂
