Forum Discussion
Excel calculation of time in step
I’m trying to calculate the amount of time that an item (part) was in each particular Step (highlighted in yellow); beginning with “recdate”, then progressing through each step 01, 03, 05, 08, 09, 10...
Are the date-times in each of the Step_* columns the date and time at which that step was completed or at which it started?
So, should the difference between step_01 and recdate be considered the time taken from step 1?
So, should the difference between step_01 and recdate be considered the time taken from step 1?
flexyourdata the date and timestamp in the Step columns are the date and time that it entered that step.
Thanks!
