calculate total hh:ss with text column

[andreaturri27]

Good Morning, 

sorry for my english.

i have "H Joker" = total minutes work 

i have "H Joker1" = total minuts work (format with text and hh:mm)

H Joker1 =

var hourNo=INT('Testa Report'[H Joker]/60)

var minuteNO=MOD('Testa Report'[H Joker],60)

var secondNo=INT(('Testa Report'[H Joker]-INT('Testa Report'[H Joker]))*60)

return

FORMAT(hourNo,"#00")&":"&FORMAT(minuteNO,"#00")

i would have under column "H Joker1" a total hours how?

thank you 

Andrea 

[amitchandak · Accepted solution]

@andreaturri27 , Create a measure like

H Joker1 =
var _m = sum('Testa Report'[H Joker])
var hourNo=INT(_m/60)
var minuteNO=MOD(_m,60)
var secondNo=INT((_m-INT(_m))*60)
return
FORMAT(hourNo,"#00")&":"&FORMAT(minuteNO,"#00")

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...