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

N

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.
 
L

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top