How to get total time duration in Hrs :mm without converting them to total hrs or minutes in dax

[msbiuser1]

Team Duration

A	05:40
A	10:20
B	11:20
B	05:50
C	06:34
C	02:45
D	05:21
D	10:20
E	06:30
E	07:40

I am looking for a dax to sum the total duration in hr:mm. Because in excel its easy , but power bi , I tried with duration datatype, not able to get the desired result.

[saravanan_p · Accepted solution]

Hi @msbiuser1 
You may use the following measure:

duration_m =

var d = sum(duration_test[Column])

var h =right("0" & rounddown(d/60,0),2)

var m=right("0" & MOD(d,60),2)

return

h&":"&m

Kindly mark as solution after your testing with a thumps up!!