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 = 2.66/40=0.0665
2.66 is the number for 2h 40min
thanks in advance!
1 ACCEPTED SOLUTION
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.
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 + hoursThen you can do a simple divide by 40.
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.
Then you can do a simple divide by 40.
