View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Geet
 
Posts: n/a
Default How do I enter a time in excel so it does not print as 1:00:00 PM

I am using Excel to create a event function sheet for a meeting. In one
column is the start time and another column is the end time. When I merge it
into a document, the start time shows as (for example)
1:00:00 PM. But the end time will print as 8:30 PM. How do I change the
start time to read as 1:00 PM?