Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering Seconds but displaying minutes & seconds | Excel Discussion (Misc queries) | |||
Formula to Change Hours:Minutes:Seconds to Seconds only | Excel Discussion (Misc queries) | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
Convert seconds to minutes and seconds in excel | Excel Worksheet Functions | |||
convert seconds to minutes and seconds | Excel Worksheet Functions |