Converting seconds into HH:MM:SS

[Switto]

Hi All,

I am trying to convert the seconds to HH:MM:SS format using "https://community.powerbi.com/t5/Desktop/How-to-convert-seconds-to-hh-mm-ss/m-p/310219#M137405" solution however ,I am getting error stating "Expression.Error: We cannot apply field access to the type Number.Details:Value=0 Key=Unit effort in Seconds".

I have used the same reference "#time(0,0,0) + #duration(0,0,0[Unit effort in Seconds])" to convert the data but it is not working.

Any help will be appreciated.

[amitchandak · Accepted solution]

@Switto ,

New column = left([col])*3600 + mid([column],3,2)*60 + right([column],2)*1

if needed refer:https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...

[Switto]

Thanks @amitchandak .

I got an error while using your suggestion, however, I tried the post you suggested and it worked 🙂