3:30 PM will be accepted as an input.

You can then choose how you wish to format the output display.
--
David Biddulph

"MJB_FI" wrote in message
...
I am creating a time card for overtime for staff and would like to make it
as
simple as possible.

I select the format for the cell to display as AM or PM, but input is
required in 24-hour clock format. This is confusing for many people. I
cannot find a format in Excel 2003 that allows for input in 12-hour
format.