DIVIDE TIME BY TIME

[Alfred05]

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!

[amitchandak]

@Alfred05 , refer if this can help

https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...

https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-i...

[AllisonKennedy · 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.