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.
|