Quote:
Originally Posted by JennEx
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)
|
Umm, how about trying it there, then?
Quote:
Originally Posted by JennEx
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
|
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:
Quote:
Originally Posted by JennEx
Real estate in the cell is tight, so I am also trying to eliminate the space between the number and the AM/PM.
|