![]() |
#3
|
||||
|
||||
![]()
Your field construction is wrong. It should be:
{ if { MERGEFIELD r2_srl }<> "" "{MERGEFIELD r2_srl \@ "h:mm"}-{MERGEFIELD r2_sru \@ "h:mm"}P"} My own preference would be: {IF{MERGEFIELD r2_srl}<> "" "{MERGEFIELD r2_srl \@ "hh:mm AM/PM"}-{MERGEFIELD r2_sru \@ "hh:mm AM/PM"}"} so the AM/PM display is correctly set by the fields themselves.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help Displaying Values and Linking | GourdoftheFries | Excel | 2 | 01-03-2019 01:19 AM |
Table with values from several locations and years - need to find comp values | Ricardo Sousa | Excel | 9 | 07-27-2018 02:06 AM |
![]() |
Ricardo Sousa | Excel | 6 | 06-09-2018 10:51 PM |
Display multiple values as new values based on selection from template. | MvdB | Excel | 2 | 09-29-2015 08:51 PM |
![]() |
Richard.p | Word | 3 | 04-21-2015 01:14 AM |