Converting seconds into HH:MM:SS

Question

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"&nbsp;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.&nbsp;&nbsp;

amitchandak · Accepted Answer

Switto ,
&nbsp;
New column = left([col])*3600 + mid([column],3,2)*60 + right([column],2)*1
&nbsp;
if needed refer:https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-dax

Forum Discussion

Converting seconds into HH:MM:SS

2 Replies

Related content

How to convert seconds to hh:mm:ss

How to convert seconds to hh:mm:ss

Convert HH:MM:SS to seconds

Converting HH:MM:SS to seconds

Convert seconds to HH:MM:SS then SUM