View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Meg
 
Posts: n/a
Default convert time to numerical vale

It is 1 minute, 4.69 seconds. Used for a database of swimming times to
determine what the time was the first time the event was swam in a season and
the number of seconds taken off each time it is swam after the first time.

Thanks!

"Meg" wrote:

Is there a way to convert a time of 1:04.69 to 64.69 in excel?

Thanks in advance!
Meg