Format Time to NOT show seconds and AM/PM

Giganews Newsgroups
Subject: Format Time to NOT show seconds and AM/PM
Posted by:  Diana
Date: Thu, 31 Jul 2008

I am bringing data with appointment Times over from another program.  I am
using a TIME formula to subtract 15 minutes off to let person know when to
show for appointment.

Problem that is occurring is how the time shows.  The time in the cell
itself shows as 1:30 but when you click on the cell & view it in the formula
bar, it shows as 1:30:00 AM.  I'm Mail Merging (WORD) this data for letters
and do NOT want the full time with seconds and AM/PM to show on the letter.
How do I format this in EXCEL so only the 1:30 shows?

Replies