I would like to input a time without the seconds showing

[Guest]

I have tried to format the cell by using both general and time formats. When
using h:mm AM/PM the seconds till show up. I am using this for a mail merge
and don't want the time to reflect seconds.

 

[Roger Govier]

Hi Tara

Format>Cells>Number>Custom> h:mm

 

[David Biddulph]

If you're talking not about how the cells are displayed in Excel, but how
the data appears in a mail merge in Word, try
http://office.microsoft.com/en-us/word/HA011164951033.aspx
The easy option is to produce a helper column using the TEXT() function.

 

[Roger Govier]

Hi

Then try
Format>Cells>Number>Custom> h:mm AM/PM