Re: Format Time to NOT show seconds and AM/PM

Giganews Newsgroups
Subject: Re: Format Time to NOT show seconds and AM/PM
Posted by:  Dave Peterson (peters…
Date: Thu, 31 Jul 2008

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:

about half way down the page.

I often cheat instead of racking my brain.

I'll insert another column (probably hidden!) and use:
(or whatever format I want)
and use that field in the mailmerge.

(Cheating doesn't bother me anymore <vbg>.)

Diana wrote:
> 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?


Dave Peterson


In response to

Format Time to NOT show seconds and AM/PM posted by Diana on Thu, 31 Jul 2008