#1
|
|||
|
|||
Field Code/Switch for Time not working
I have an Excel sheet with a start time field that is formatted as "HH:mm". I also have a Word document with information about a person's start time at an event. When I insert the merge code the field shows 0.8125. So it is not even in the normal hours/minutes/seconds format. When I toggle field codes I get { MERGEFIELD Start_Time }. I then enter a switch to the field code { MERGEFIELD Start_Time \@"HH:mm"} and then update field. I get the same result of 0.8125. Any ideas on how to get this to work for me? Thank you in advance for taking the time to look at this. |
#2
|
||||
|
||||
Are there data other than times in the Excel column? If so, that is the most likely cause of the problem. For an explanation, see Mailmerge Data Format Problems in the Mailmerge Tips and Tricks thread at the top of this forum:
https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to format a picture switch in a merge field to only include the numbers in the middle? | becca | Mail Merge | 2 | 06-08-2016 01:15 PM |
Add Time Code | ossosso | Word | 14 | 01-07-2016 05:10 AM |
a code to add altering time to cells | tesoke | Excel Programming | 3 | 12-17-2015 12:31 PM |
To me the code on the youtube tutorial looks the same as mine but a I get a run-time | chrisd2000 | Excel Programming | 1 | 07-02-2014 11:23 AM |
my Outlook Calendar didn't switch to Standard time... | kali90 | Outlook | 0 | 03-12-2013 08:02 AM |