How to convert mm:ss to seconds (duration)

[diskovered]

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

[Ramaka_bnd]

Split the column into two columns. One for minutes and one for seconds with the type number.

Then add a new column with like this
AddColNewSpeaktime = Table.AddColumn(ChangeColType, "Ø Sprechzeit", each #duration(0,0,[Ø Sprechzeit.1],[Ø Sprechzeit.2])),
AddcolNewWaittime = Table.AddColumn(AddColNewSpeaktime, "Ø Wartezeit", each #duration(0,0,[Ø Wartezeit.1],[Ø Wartezeit.2])),
#duration(0,0,0,0) need the type number

[mwegener · Accepted solution]

Hi @diskovered

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

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

[Anonymous]

Could you please explain this in more detail?

I have durations in my data set that are, for example, 7 minutes 17 seconds, but powerBI auto formats the duration to be 7 hours 17 minutes 0 seconds. How can I change this?

[mwegener]

What is your source?

Is there a "Changed Type" step?

Maybe you could insert a "Add Prefix" step before the "Changed Type" step and change the value to this format "00:07:17".

[diskovered]

Thanks. 

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