View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
 
Posts: 913
Default 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