Reply
Regular Visitor
Posts: 18
Registered: ‎07-20-2018
Accepted Solution

How to convert mm:ss to seconds (duration)

[ Edited ]

How do I convert this to seconds either via measure or m. Help is much appreciated. Thanks

 

convert.PNG


Accepted Solutions
Member
Posts: 83
Registered: ‎11-16-2018

Re: How to convert mm:ss to seconds (duration)

Hi @diskovered

 

format the column with Power Query (M) as duration.

With Duration.TotalSeconds([Column]), you get the seconds.

 

Duration.png

View solution in original post


All Replies
Member
Posts: 83
Registered: ‎11-16-2018

Re: How to convert mm:ss to seconds (duration)

Hi @diskovered

 

format the column with Power Query (M) as duration.

With Duration.TotalSeconds([Column]), you get the seconds.

 

Duration.png

Highlighted
Regular Visitor
Posts: 18
Registered: ‎07-20-2018

Re: How to convert mm:ss to seconds (duration)

Thanks. 

 

Got mine to work = Table.TransformColumns(#"Changed Type",{{"Value - Copy", Duration.TotalSeconds, type number}})