Thread: How do I enter time (12-hour clock) & have it display it?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
  
Posts: 510
Default How do I enter time (12-hour clock) & have it display it?
format the cell, custom, h:mm AM/PM
note, they will have to put a space before the AM/PM

"MJB_FI" wrote:

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.
Reply With QuoteReply With Quote