Change Column (Hour, minutes) to Minutes

[Anonymous]

Hello Everyone!

I need to change a column wich is in the next format: 1:02:03 (hh:mm:ss) and I want to know how many minutes are (62 min)

I will appreciate some help!

Christian 

[V-pazhen-msft · Accepted solution]

@Anonymous 
Just create a simple calcuate column Column:

Minute = HOUR([Time])*60+MINUTE([Time])

Or create a sutome column in Power Query:

Time.Hour([Time])*60 + Time.Minute([Time])

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Minutes = 
Var _Hours = FORMAT('Table'[time],"h")*60
Var _Minutes = FORMAT('Table'[time],"n")
Var _second = ROUND(FORMAT('Table'[time],"s")/60,0)

return
_Hours+_Minutes+_second

[jthomson]

Split it by a delimiter and make a custom column that does first column x60 plus the second column?