How do I convert time as text 'mm:ss to time value in Excel
Assuming all the entries in question follow the same format: 'mm:ss
Try this...
Select the range of cells in question
Goto the menu EditReplace
Find what: ' (enter an apostrophe)
Replace with: 0:
Replace All
Then format the cells in the Time format of your choice.
--
Biff
Microsoft Excel MVP
"Sholto" wrote in message
...
I have time stored as text in the format 'mm:ss (e.g. '25:15)
Note
the leading apostrophe.
Every Excel function & format I try assumes the minutes are hours and the
seconds minutes. I can manually edit cell to 0:mm:ss to get the
functionality
I need but have 2000 rows to edit...
Any ideas would be much appreciated.
|