![]() |
|
#1
|
||||
|
||||
![]()
So what do you get with just:
{IF{MERGEFIELD r1_relchg}<> "" "{MERGEFIELD r1_srl \@ "h:mm"}-{MERGEFIELD r1_sru \@ "h:mm"}"}
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#2
|
|||
|
|||
![]()
That worked Paul. It blows my mind that we we were able to concatenate two time strings with simple switches, but to simply use time as itself in a field required a paragraph of formula. (mind you I haven't tried this in the actual report yet ... it may behave quite differently)
How can the A or P for AM or PM be added? I tried the standard method of formatting but it came out looking like this ... 9:30九P -10:00九P {IF{MERGEFIELD r1_relchg}<> "" "{MERGEFIELD r1_srl \@ "h:mmA/P"}-{MERGEFIELD r1_sru \@ "h:mmA/P"}"} |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Richard.p | Word | 3 | 04-21-2015 01:14 AM |
Save merged document as concatenated merge field values | texas791 | Word VBA | 4 | 02-25-2014 07:35 PM |
![]() |
silverspr | Excel | 7 | 03-03-2013 04:45 PM |
Concatenated data in subsequent rows | doorsgirl | Excel | 4 | 09-15-2011 10:37 PM |
![]() |
vikrantkale | Word | 1 | 03-28-2011 06:13 PM |