Thread: Text or numbers to hh:mm
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
quinto via OfficeKB.com quinto via OfficeKB.com is offline
external usenet poster
  
Posts: 1
Default Text or numbers to hh:mm
I have a column that has numbers as followed 630, 530, 1030 represting times,
I need to convert these numbers to 6:30, 5:30, 10:30 and so on.

Thanks
Quinto

--
Message posted via http://www.officekb.com

Reply With QuoteReply With Quote