Either enter the times using the PM
1:00:00 PM
or use a 24 hour clock:
13:00:00

If you use a 12 hour clock and don't give excel any AM/PM information, it'll
assume you mean AM.

bgcooker wrote:

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?

--

Dave Peterson