View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_934_] Rick Rothstein \(MVP - VB\)[_934_] is offline
external usenet poster
 
Posts: 1
Default text in mm:ss to time

Do you mean you want to convert them in place? Select the cells containing
these "text times", click Data/Text To Columns on Excels menu bar and click
Finish on the dialog box that appears. You might have to then format the
cells to display the way you want.

Rick


"P Boric" wrote in message
...
_I have times in text format as mm:ss (eg. 03:45) and want to convert them
to
time numbers in the same format.