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

You can use a custom format like:
[ss].00
Or the TEXT function, with that format:
=TEXT(A1,"[ss].00")

Hope this helps,
Miguel.

"Meg" wrote:

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

Thanks in advance!
Meg