Thread: How do I enter 1635 and see 4:35 PM in the cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MartinW[_2_] MartinW[_2_] is offline
external usenet poster
  
Posts: 168
Default How do I enter 1635 and see 4:35 PM in the cell?
Hi Kim,

Chip Pearson has a way here,
http://www.cpearson.com/excel/DateTimeEntry.htm

HTH
Martin



"kimrich" wrote in message
...
In a spreadsheet, how can I quickly enter 3 or 4 time numbers and have
excel
convert those numbers to a standard time AM or PM format?


Reply With QuoteReply With Quote