Forum Discussion

diskovered's avatar
diskovered
Icon for Helper III rankHelper III
7 years ago
Solved

How to convert mm:ss to seconds (duration)

How do I convert this to seconds either via measure or m. Help is much appreciated. Thanks  
Need Help
Tutorial Requests
  • mwegener's avatar
    mwegener
    7 years ago

    Hi diskovered

     

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

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

     

Ramaka_bnd's avatar
Ramaka_bnd
Regular Visitor
3 years ago

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