How to convert minutes (a measure) to hours and minutes

[boa]

Hello

I just want to convert minutes (a measure of duration of appointments) to hours and minutes. I can calculate the hours but have problems with the minutes (in the same expression).

Can anyone tell me how to get the column hh:mm.

Thanks in advance!

[v-yangliu-msft · Accepted solution]

Hi  @boa ,

Here are the steps you can follow：

1. Create measure.

Measure =
var hourNo=INT([Sum duration]/60)
var minuteNO=MOD([Sum duration],60)
return
FORMAT(hourNo,"#00")&":"&FORMAT(minuteNO,"#00")

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[boa]

Thank you, it works!

[DataInsights]

@boa,

See if you can adapt this solution:

https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486