How do I change a minutes and seconds as a 2400 time to seconds?
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. |
How do I change a minutes and seconds as a 2400 time to seconds?
On Sun, 10 Aug 2008 13:04:00 -0700, NickBrown419
wrote: 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 |
All times are GMT +1. The time now is 09:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com