How to averege a time conversion

[Alvim102]

Hello guys, I have a column called talking_time but in seconds, I did a conversion using the formula below:

Talking Time =

var T = SUM([talking_time])

var H = INT(T / 3600)

var M = INT((T - (H * 3600)) / 60)

var S = MOD(T, 60)

return

H * 10000 + M * 100 +  S

And then I have the result like this 12:55:15 for example, but when I use the averege formula on [Talking Time] I have the result like 05:89:25, the minutes are wrong, the correct one is up to 59 and after that it adds an hour.

How can I fix this?

[tamerj1 · Accepted solution]

Hi @Alvim102 

Talking Time =
VAR T =
    SUM ( 'Table'[talking_time] )
VAR H =
    FORMAT ( QUOTIENT ( T, 3600 ), "00" )
VAR M =
    FORMAT ( QUOTIENT ( MOD ( T, 3600 ), 60 ), "00" )
VAR S =
    FORMAT ( MOD ( MOD ( T, 3600 ), 60 ), "00" )
RETURN
    H & ":" & M & ":" & S