Microsoft Office Forums Field Code/Switch for Time not working

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-20-2016, 11:51 AM
Ozzie2842 Ozzie2842 is offline Field Code/Switch for Time not working Windows XP Field Code/Switch for Time not working Office 2007
Novice
Field Code/Switch for Time not working
 
Join Date: Aug 2013
Posts: 1
Ozzie2842 is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 12-20-2016, 01:08 PM
macropod's Avatar
macropod macropod is offline Field Code/Switch for Time not working Windows 7 64bit Field Code/Switch for Time not working Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,577
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Field Code/Switch for Time not working 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
Field Code/Switch for Time not working Add Time Code ossosso Word 14 01-07-2016 05:10 AM
Field Code/Switch for Time not working 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


All times are GMT -7. The time now is 04:18 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft