Decimal to minutes and seconds

[Anonymous]

HELP! I have the next values :

When i open Power Query I set the data as duration and I can see the seconds and minutes, BUT when i close and apply this is the data I get 😞  I have tried the many solutions I found here but none has worked, I have no idea what to do next please help. 

PS: I tried this code but I get error 

Conversacion real time =

VAR _Seconds = SELECTEDVALUE('1'[CONVERSACION REAL.1])

VAR _Minutes = INT ( DIVIDE ( _Seconds, 60 ) )

VAR _RemainingSeconds = MOD ( _Seconds, 60 )

VAR _RemainingMinutes = MOD ( _Minutes, 60 )

RETURN

IF (

NOT ISBLANK ( _Seconds ),

FORMAT ( quotient(_Seconds,60), "00" ) & ":" & FORMAT ( mod(_Seconds,60), "00" ))

[v-zhangti · Accepted solution]

Hi, @Anonymous 

There is not much problem with your formula.

Column:

You also need to convert the text format to a time format. You can use the function TIMEVALUE. 

TIMEVALUE function (DAX) - DAX | Microsoft Learn

Conversacion real time = 
 VAR _Seconds = [Time]
VAR _Minutes = INT ( DIVIDE ( _Seconds, 60 ) )
VAR _RemainingSeconds = MOD ( _Seconds, 60 )
VAR _RemainingMinutes = MOD ( _Minutes, 60 )
RETURN
TIMEVALUE(IF (
NOT ISBLANK ( _Seconds ),
FORMAT ( quotient(_Seconds,60), "00" ) & ":" & FORMAT ( mod(_Seconds,60), "00" )))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Pls help again. I get this data, is there a way to also show seconds? for example 17.39 = 00:17:23, thank you in advance 🙂 

[Anonymous]

YES! thank you so much, it is now in hh:mm:ss format. 🎊

[amitchandak]

@Anonymous , Change data type time and try

Or create a new column in dax

time(0,0,0) + [Column in hours]/24

or

time(0,0,0) + [Column in Minute]/(24*60)