Thread: Time input mask format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
WNB-96740
 
Posts: n/a
Default Time input mask format
If I input - "340 a", I want it to show "3:40 AM"

or if I input 1230 p, I want it formated as 12:30 PM

can this be done?
Reply With QuoteReply With Quote