I want to be able to enter a time as a 12-hour time in one column of cells
and have the time entered as formatted as AM. I want to do the same in
another column of cells and have those cells format the time as PM. How do I
accomplish this?