How would I finish this formula to conver HH:MM:SS to just Minutes

[rmartori]

So I found this formula but it is only for HH:MM

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

When seconds come into play it falls apart.

I am using the formula tool. 

[Emil_Kos]

Hi @rmartori,

I have prepared the example with substring formula.

Please take a look and mark as solved if this was helpful.

[Qiu]

@rmartori 

If you like this, appreciate you would make it as accept.

---

Count the Seconds, Column needs to be Double
Round(ToNumber(Right([HH:MM:SS],2))/60,0.01)+ ToNumber(Substring([HH:MM:SS],4,2))+60 * ToNumber(Left([HH:MM:SS],2))

Dump the seconds
ToNumber(Substring([HH:MM:SS],4,2))+60 * ToNumber(Left([HH:MM:SS],2)]

---