Hi, thanks for any assistance. I’m working on quantifying the time that I am spending on each of the steps in my production line, and am using a datediff formula to compare the last modified date to the start date, divided by the quantity of the steps i have completed. It works great to give me an average of each of the steps, but I would like to be able to also get a “lap” time for the current step. In other words, if i have done the step 10 times in 15 minutes, that means it is 1.5 minutes per step, but i would like to know that the last iteration took 1.4 minutes, vs the previous one was 1.6 minutes, etc. The goal is to know both the average and then the last one, so i can keep track of how i’m doing. Whatever formula i am trying to create is not able to compare the last modified time of the current iteration to the previous one.
Any ideas?
