Average Time Not Showing Correctly

[Forecaster]

Hi everyone 

I have a duration column which shows seconds and is a whole number.

I can get the average duration by using the formula:

avg = AVERAGE(Query1[Duration])

this gives me an aveage duration of 6570 seconds which is correct.

What I want to do is to convert this to HH:MM:SS

so I tried the following:

AvgTime = FORMAT(AVERAGE(Query1[Duration]),"HH:MM:SS")

This gives me a time of 00:23:02 which is not correct if you convert 6570 seconds to hours and mins.

What am I missing? 

Thanks 

[Forecaster · Accepted solution]

I managed to solve this by doing the following:

HHMMSS = 
INT(Query1[avg] / 3600) & ":" &
RIGHT("0" & INT(([avg] - INT([avg] / 3600) * 3600) / 60), 2) & ":" &
RIGHT("0" & MOD([avg], 3600), 2)

[Greg_Deckler]

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

[Forecaster]

Hey, thanks for your reply. I think I need more context here, I don't see how this is solving my issue?