Forum Discussion
Solved
DIVIDE TIME BY TIME
Hey there, I have a measure thar adds up the time by user, as the image below...I would like to find a way to divide that time by 40 hours, and get the result as a number i.e. 2:40:00/40:00:00...
- What measure are you using for SUM_Cycle_Time? You need to convert the original time into a decimal first, so basically take the minute component and divide by 60 + hours
Then you can do a simple divide by 40.
