Thread: How do I convert time as text 'mm:ss to time value in Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sholto Sholto is offline
external usenet poster
  
Posts: 1
Default How do I convert time as text 'mm:ss to time value in Excel
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.



Reply With QuoteReply With Quote