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.
|