|
#1
|
|||
|
|||
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"}"} |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Printing selected pages based on a MERGEFIELD.g. If MERGEFIELD=x then print pages 1,2,4 if MERGEFIEL | 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 |
Search with multiple strings | silverspr | Excel | 7 | 03-03-2013 04:45 PM |
Concatenated data in subsequent rows | doorsgirl | Excel | 4 | 09-15-2011 10:37 PM |
update style of all strings available between two specific strings | vikrantkale | Word | 1 | 03-28-2011 06:13 PM |