Forum Discussion
Convert time duration into total minutes
Hi All,
I am stuck here on furmula.
Can you advice me what formula to use to convert time duration into total minutes in power query?
example below 0:03:55:39 into 235 minutes(3 hr = 3*60=180 min+55min = 235min)
any help is highly appreciated
Hi Anonymous ,
Check this function:
https://docs.microsoft.com/en-us/powerquery-m/duration-totalminutes
2 Replies
camargos88Community Champion
Hi Anonymous ,
Check this function:
https://docs.microsoft.com/en-us/powerquery-m/duration-totalminutes
- Greg_Deckler
Anonymous - Should be similar in concept to the DAX way of doing it. https://community.powerbi.com/t5/Quick-Measures-Gallery/Duration-to-Seconds-Converter/m-p/342279#M92
You would have to use things like https://docs.microsoft.com/en-us/powerquery-m/duration-minutes
and duration-hours, etc.
