Hi Jenn,

Have you tried the time mergefield without the switch? Word ordinarily converts it to the AM/PM format without it. You should only need the switch to eliminate seconds from the output.

As for the date, if it's displayed as a serial number in Excel, that's what you'll get in Word. To convert the serial number to a date, you'd require field code like:
{QUOTE
{SET jd{=2415019+{ MERGEFIELD Date }}}
{SET e{=INT((4*(jd+32044)+3)/146097)}}
{SET f{=jd+32044-INT(146097*e/4)}}
{SET g{=INT((4*f+3)/1461)}}
{SET h{=f-INT(1461*g/4)}}
{SET i{=INT((5*h+2)/153)}}
{SET dd{=h-INT((153*i+2)/5)+1}}
{SET mm{=i+3-12*INT(i/10)}}
{SET yy{=100*e+g-4800+INT(i/10)}}
"{dd}-{mm}-{yy}" \@ "dddd, d MMMM yyyy"}

Note: The field brace pairs (ie '{ }') for the above example are created in the document via Ctrl-F9 (Cmd-F9 on a Mac) - you can't simply type them or copy & paste them from this message.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]