Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 04-27-2017, 08:20 PM
macropod's Avatar
macropod macropod is offline Help With Time Fields Windows 7 64bit Help With Time Fields Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

ISTR this field code was required because you had the Excel workbook open when the merge was done, and that was messing with the formats. The 'N/A' was for those cases when the lights would not be used.

Try:

{IF{MERGEFIELD LIGHTS_ON_TIME}= "" "N/A" {MERGEFIELD LIGHTS_ON_TIME \@ "h:mm AM/PM"}}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help With Time Fields Odd Result In Combined Merged Time Fields JennEx Mail Merge 9 04-29-2017 08:58 AM
Help With Time Fields Employee Turnover by Department/Month split between Voluntary/Involuntary - Full-time/Part-time CPSmith Excel 1 03-26-2016 02:48 AM
Help With Time Fields Displaying FORMTEXT fields when merge fields are empty or null sfkHooper Mail Merge 6 01-19-2016 04:24 PM
How do you get the DATE and TIME fields to be included in an export to Excel? tpieples Outlook 0 02-18-2013 12:11 PM
Word 2010 - DOCX File with fields -> PDF with fields senglory Word 2 03-27-2012 10:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:14 PM.


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