Thread: Omiting AM/PM
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kojak kojak is offline
external usenet poster
 
Posts: 7
Default Omiting AM/PM

How can I get time to display without the AM or PM after it, using 12 hour
day? I am wanting something like 2:30 pm to display as just 2:30 and not as
14:30.
Thanks in advance.