Converting HH:MM to just MM

[Altrx]

How to convert a column with HH:MM to just minutes 

E.g., I have 1:20 then the output should be 80

[jdunkerley79 · Accepted solution]

Two options (using formula tool):

 Just the minute part:

ToNumber(Right([HH:MM],2))

(assuming you want as a number otherwise just 

Right([HH:MM],2)

Total minutes:

ToNumber(Right([HH:MM],2))+ 60 * ToNumber(Left([HH:MM],2))

Quick sample attached