Duration data type doesnt sum

[Anonymous]

Converted a column from string to durations but upon checking at data tab it automatically changed into decimal. Since I need to calculate the sum of Talk time (most likely minutes and seconds). but it shows 00:00:00

Here's my dax formula:

Temp Talk =

VAR Calc =  IFERROR(CALCULATE(sum('Queue Performance Detail'[Total Talk])/sum('Queue Performance Detail'[Handle])/60000),"")

Return

IF(Calc="",BLANK(),FORMAT(Calculate(Calc/1440),"hh:MM:ss"))

*converted 'Queue Performance Detail'[Total Talk] to duration

*converted 'Queue Performance Detail'[Handle] to whole number.

[Greg_Deckler]

@Anonymous Chelsie Eiden's Duration - Microsoft Power BI Community