How do I change a minutes and seconds as a 2400 time to seconds?

[NickBrown419]

I need to change a minutes and seconds formatted automatically on the 2400
clock to just seconds for a metric. For example 4 minutes 35 seconds is
currently shown as 00:04:35. Anyone know how to automatically format it back
to minutes/seconds and then I can convert to seconds.

 

[Lars-Åke Aspelin]

I need to change a minutes and seconds formatted automatically on the 2400
clock to just seconds for a metric. For example 4 minutes 35 seconds is
currently shown as 00:04:35. Anyone know how to automatically format it back
to minutes/seconds and then I can convert to seconds.

To get the number of second, multiply with 86400 (which is the number
of seconds in 24 hours) and format the result as number.

Hope this helps / Lars-Åke