It's not at all apparent to me how your AM/PM times are differentiated. When I filter on SB1, I see that your 'AM or PM' column has nothing for the first few rows, then 2 PM entries followed by 5 AM entries, 2 PM entries, 1 AM entry, 1 PM entry, 2PM entries, etc. I can't see how this relates to:
Quote:
|
I want "AM" for every other row that contains "SB1", and "PM" for all remaining rows that contain "SB1."
|
In any event, to convert a time in column C from AM to PM, just add 0.5 to the time value there. To do that, input 0.5 into any cell, copy it, then select the cell(s) you want to update and choose Paste>Paste Special>Values>Add>OK.