Field Code/Switch for Time not working

Ozzie2842 · #1 12-20-2016, 11:51 AM

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.

macropod · #2 12-20-2016, 01:08 PM

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

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