Change decimal to duration

[Anonymous]

I have a column in a table called duration which is in decimal format, for example, 34.60 but I need to change that to mm:ss format so instead it should be 34minutes 36 seconds , or 34:36. 

How would I be able to do this? 

[MahyarTF]

Hi,

Create the column as below : 

Time = time(0,

            hour(FORMAT(TIME(TRUNC(Sheet229[Duration],0),(Sheet229[Duration]-TRUNC(Sheet229[Duration],0))*60,0),"long time")),

            minute(FORMAT(TIME(TRUNC(Sheet229[Duration],0),(Sheet229[Duration]-TRUNC(Sheet229[Duration],0))*60,0),"short time"))

        )

******** Sheet229[Duration] is my decimal column

Appreciate your Kudos

Please mark it as solution if it helps 

[MahyarTF · Accepted solution]

Also, If you want to do it in Power Query, change the type of your column to Text(or create the new one as text) and then create the new column as a below :

Text.BeforeDelimiter( [Duration],".") & ":" & Number.ToText( Number.FromText( Text.AfterDelimiter( [Duration],".")) *6)

[Dinesh_Suranga]

@Anonymous ,

Hi

Do you want this in DAX or Power query?

Thank you.

[Anonymous]

Power Query is fine, but what is the DAX Solution?

[Dinesh_Suranga]

@Anonymous ,

Hi,

You can try following code to create new column in power query.

= Text.BeforeDelimiter( [Duration],".") & ":" & Number.ToText( Number.FromText( Text.AfterDelimiter( [Duration],".")) *0.6)

 Thank you.

[Anonymous]

Error

[Dinesh_Suranga]

@Anonymous 

Hi

May I know the error?