Odd Result In Combined Merged Time Fields

		Microsoft Office Forums > Microsoft Word > Mail Merge
Odd Result In Combined Merged Time Fields

FAQ

Thread Tools

Display Modes

04-28-2017, 03:14 PM

macropod

Windows 7 64bit Odd Result In Combined Merged Time Fields

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

Try:

{IF{MERGEFIELD r1_srl}= {MERGEFIELD r1_sru} "" "{SET A {IF{MERGEFIELD r1_srl \@ "AM/PM"}= "AM" "A" "P"}}{SET B {IF{MERGEFIELD r1_sru \@ "AM/PM"}= "AM" "A" "P"}}{MERGEFIELD r1_srl \@ "h:mm"}{IF{REF A}={REF B} "" {REF A}}-{MERGEFIELD r1_sru \@ "h:mm"}{REF B}"}

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding sequential Number in a document that already has merged fields inserted	Highlander01	Mail Merge	3	01-19-2016 12:33 PM
Time allotted minus time used with result in hour and minute	esther6086	Excel	2	04-29-2014 05:03 PM
Formatting Merged Time Values Between Excel & Word	JennEx	Mail Merge	1	07-12-2012 02:54 PM
combined in-box for webmail accounts	sonoman	Outlook	1	07-19-2011 02:50 PM
word and excel combined	jasperman	Word	1	08-23-2010 06:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:16 AM.