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.
Hi @rmartori,
I have prepared the example with substring formula.
Please take a look and mark as solved if this was helpful.
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)]