Thread: convert time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ann ann is offline
external usenet poster
 
Posts: 210
Default convert time

I need to be able to type in numbers and minutes very quickly, example 1 min
24 sec, and have it automatically convert it to all seconds. So if i type
in 1.24 it becomes 84.

Any thoughts. thanks!