Hey Paul ...

This is what I came up ....

I got the same results as you ... and they weren't really the results I was looking for.

With my data, one record with r1_relchg = "REL", I was given the following results with both scripts:

12:00 A-12:00 A



r1_srl = 9:30 AM ... confirmed time value, no other dta in the column, just blank cells.
r1_sru = 10:00 AM ... confirmed time value, no other dta in the column, just blank cells.

Real estate in the cell is tight, so I am also trying to eliminate the space between the number and the AM/PM.

Attached Files

12.docx (15.7 KB, 9 views)

Umm, how about trying it there, then?

The standard field code for the AM/PM is:

{IF{MERGEFIELD r1_relchg}<> "" "{MERGEFIELD r1_srl \@ "h:mm AM/PM"}-{MERGEFIELD r1_sru \@ "h:mm AM/PM"}"}

but I didn't bother with that because you said:

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

Turns out the simple method didn't work in the report. All I was able to manage with that was concatenated decimals.

The original (long) way of doing it seems to be working so far, and with it I managed to just retain either the A or P of AM/PM with the time.

I often format my times in Excel as h:mmA/P which leaves me with 8:30A. I just assumed this was possible in Word as well, so that's what I was aiming for.

Thanks Paul!