Convert number of minutes to hours and minutes

[Anonymous]

Hi

I have a column which has number of minutes such as 90, 315, 225 etc.I need to be able to convert this into hours and minutes and also to be able to sum this at the end.

I tried a calculated column with the measure below however this converts into a text format and I cannot sum the data from there.

any help would be greatly appreciated

Duration Fomatted = FORMAT(Table1[Duration Minutes] / 60 / 24, "h:mm")

[Greg_Deckler · Accepted solution]

@Anonymous See if this helps: Chelsie Eiden's Duration - Microsoft Power BI Community