Forum Discussion
Calculation of data that occurs one after each entries
Hellotauqeeracma ,
Its great to see that you solved it very simply. I admire your thinking. Thank you.
The second requirement is simple from now, You already calculated the Quantity for production, now we need to find the time required for each production and each stops. The time with respect to zeros are stop time and the time with respect to number >0 are considered as run time.
For the first production in your example file, production is 14.8, now how much time it took to produce this quantity. Similarly for all the produced quantiy and what is the stop time between each production stage..... like that. I hope you understand.
I really appreaciate your great effort to help me. Thank you so much.
Hello Pandiyarajgnanasekar,
Based on your explanation the second requirement is also solved in the attached file.
You will also find formula explanation about how "Time Consumed" is calculated.
Hope it works as desired.
Thanks
Tauqeer