View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NickBrown419 NickBrown419 is offline
external usenet poster
 
Posts: 1
Default 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.