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)
Tune to your needs:
DAX way
Removal Time = 'Table'[Time In] + Time(7, 30, 0)
M Query way
= Table.AddColumn(#"Changed Type", "Removal Time", each [Time In] + #duration(0, 7, 30, 0), type time)
Hope this helps