Forum Discussion
Solved
Time calculation to predict end time
Could not find a solution that was similar to what I need. I am not sure how to calculate the end time for a particular item. Basically we have a start time (ex. 08:15am) with a 7.5hr cycle, to be re...
I hope this works, I just divided Cycle Time by 24 (here 24 is hours in a day)
HamedM1125
Advocate III
Advocate IIIHi Pricef1 ,
You can do this in M query but before that you need to have Date and Time columns combined.
After combining it, create a custom column in M query as:
= [Date] + #duration(0,0,0,27000)
--here 27000 is in seconds (7.5 hours)
Result:
Thanks,
Hamed
Is there a way to have it update automatically? For example not all cycle times are the same. Could vary from 6hrs to 7.5hrs depending on product. Time in * Cycle Time / ?????? maybe?
- HamedM1125
I hope this works, I just divided Cycle Time by 24 (here 24 is hours in a day)
Modified just slightly and it gave me the exact times I was looking for!! Thank you for your help
- HamedM1125
Awesome! Please mark my reply as a solution 🙂