How do I enter time (12-hour clock) & have it display it?

M

MJB_FI

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.
 
D

dlw

format the cell, custom, h:mm AM/PM
note, they will have to put a space before the AM/PM
 
D

David Biddulph

3:30 PM will be accepted as an input.

You can then choose how you wish to format the output display.
 
D

David Biddulph

Remember that the cell format does not affect the accepted input format, but
merely the display of output.
Interpretations of input formats are governed by Windows Regional Options
(under Control Panel).
Things like 3:30 PM should be accepted by default.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display time format 1
"h:mm" format, but 12-hour time, not 24-hour time? 4
changing clock time to 12 hour format 1
display time in 12 hour format 1
Daily Time Sheets with Rounding 1
Time formatting in Excel 2003 2
counting cells within certain time frames - 24 hour clock 4
Create a timecard that can calculate time on a 12 hour format? 2

Top