Time formula error

[Steve]

After entering some times in an Excel spreadsheet,
formatting the "TIME" column under the category of Time
and the "1:30 PM" Type and merging into a Word document,
the time shows as 1:30:00 PM.

Does anyone know how to get rid of the seconds
indication? I noticed that MS shows this was an issue
with MS Works (see knowledge base 239208) but with little
success to a fix.

Any suggestions are greatly appreciated.

Thx,
Steve

 

[Charles Kenyon]

You might want to ask in an Excel group rather than a Word group.
--

Charles Kenyon

See the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Steve,

Use Alt=F9 to toggle on the field codes and add the following formatting
switch inside the closing } of the mergefield in the mailmerge main
document.

\@ "h:mm AM/PM"


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Mary]

Go to word help and General Switches. It will tell you how
to get rid of this in a merge document.Mary