cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Convert number(minutes) to mm:ss

Hi!

I have a column which contains the duration of actions in minutes. I made a measure which is the sum of minutes divided by a certain value, so i got a number which is an average basically. And for example its 10,75. The question is: How can convert its measure to see 10:45(mm:ss) instead of 10,75(number).

Thanks for help!

1 ACCEPTED SOLUTION
Super User

Hi @Anonymous

Try this for your new calculated column. Table1[CurrentColumn] is the column with the minutes in number format

```NewColumn =
VAR _Mins = TRUNC(Table1[CurrentColumn])
VAR _Secs = (Table1[CurrentColumn] - _Mins) * 60
RETURN
_Mins & ":" & FORMAT(_Secs;"00")```

2 REPLIES 2
Super User

Hi @Anonymous

Try this for your new calculated column. Table1[CurrentColumn] is the column with the minutes in number format

```NewColumn =
VAR _Mins = TRUNC(Table1[CurrentColumn])
VAR _Secs = (Table1[CurrentColumn] - _Mins) * 60
RETURN
_Mins & ":" & FORMAT(_Secs;"00")```

New Member

The above didn't work for me, but replacing it with comma instead of semicolon was the trick:

```NewColumn =
VAR _Mins = TRUNC(Table1[CurrentColumn])
VAR _Secs = (Table1[CurrentColumn] - _Mins) * 60
RETURN
_Mins & ":" & FORMAT(_Secs,"00")```