Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2008

Tip: Looking for answers? Try searching our database.

Format Time to NOT show seconds and AM/PM

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Diana - 31 Jul 2008 18:26 GMT
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 - 31 Jul 2008 18:50 GMT
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
  http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx

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

  http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm

about half way down the page.

==========
I often cheat instead of racking my brain.

I'll insert another column (probably hidden!) and use:
=text(a2,"ddmmyy")
or
=text(a2,"mm:ss.0")
or
=text(a2,"00000")
(or whatever format I want)
and use that field in the mailmerge.

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

> 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
[quoted text clipped - 5 lines]
> 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?

Signature

Dave Peterson

Diana - 31 Jul 2008 19:39 GMT
Thanks to much!!

> Debra Dalgleish posted this:
>
[quoted text clipped - 33 lines]
> > 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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.