I hope this is not a trick question!

Just type 11:00 pm

must include the single space prior to the pm (or am)
--
Gary''s Student - gsnu200814


"ub" wrote:

Hi
:
: I want the user to input time in one of the cells in 12 hrs format.
: Example, user should only be able to enter 11:00 am or 11:00 pm.
: Is there any way to do this.
:
: Thanks