Thread: convert number format to time format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
fullymooned[_3_] fullymooned[_3_] is offline
external usenet poster
  
Posts: 1
Default convert number format to time format
I have a whole column in which I need to be able to enter a number an
it should convert it to the time format. If I enter 100 it shoul
convert it to 1:00. Similarly entering 2300 should automatically b
converted to 23:00.

Thank yo

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote