core.noscript.text
How to convert a column with HH:MM to just minutes
E.g., I have 1:20 then the output should be 80
Solved! Go to 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