convert miliseconds to minutes:seconds

[Anonymous]

i have the following column duration in a table.

Duration

3000

2000

4000

70000

13000

want following output

Mins:sec

0.03

0.02

0.04

1.01

2.01

[themistoklis · Accepted solution]

Hi @Anonymous

First i think you have a few errors with your raw data.

Instead of 13000 it should be 130,000 and the conversion will be 02:10 instead of 2.01

Same for 70000. It needs to be 01:10.

Please see workspace with the conversion on this link.

You need to create the following 2 calculated columns:

Duration New = 'Table'[Duration] * 0.001   // Conversion from milliseconds to seconds

Conversion = 
VAR Minutes =
    INT ( 'Table'[Duration New] / 60)

VAR Seconds =
    ROUNDUP(MOD ( 'Table'[Duration New], 60 ),0) // We round up here to get a whole number

VAR M =
    IF (
        LEN ( Minutes ) = 1,
        CONCATENATE ( "0", Minutes ),
        CONCATENATE ( "", Minutes )
    )
// Seconds with leading zeros
VAR S =
    IF (
        LEN ( Seconds ) = 1,
        CONCATENATE ( "0", Seconds ),
        CONCATENATE ( "", Seconds )
    )
RETURN
CONCATENATE(CONCATENATE(M, ":"), S)

[Anonymous]

want to show in a bar chart employe wise call duration 

when i was sum the conversion column its not give expected output in a chartconversion column works like thisexpect like this

[themistoklis]

Make sure that the conversion column is not text format.
If it is, change it from modelling tab to mins:secs

[Anonymous]

How to change it to mins:sec and what is modelling tab?

can you please explain, this would be helpful, really.

Thanks @themistoklis