Forum Discussion
M Language - convert duration to seconds
If you look on the right hand side of this web page, you'll see a 'Recommendations' panel and they might help you.
Alternatively, if you get the column into a duration data type, you can use function:
https://learn.microsoft.com/en-us/powerquery-m/duration-totalseconds
If you look on the right hand side of this web page, you'll see a 'Recommendations' panel and they might help you.
Alternatively, if you get the column into a duration data type, you can use function:
https://learn.microsoft.com/en-us/powerquery-m/duration-totalseconds
Thanks. They're all about how to do it in DAX though, and I think I can do that. I'm trying to do it in M/Power Query, rather than going through the process of 'copy column, split by delimiter, do arithmetic, delete columns again' 15 times. Sorry, guess I'm being lazy!
