Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter time (12-hour clock) & have it display it?
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting cells within certain time frames - 24 hour clock | Excel Discussion (Misc queries) | |||
24 hour clock formula for elapsed time between 1215 and 1630 | Excel Worksheet Functions | |||
Incremental time values based upon clock in and clock out times | Excel Discussion (Misc queries) | |||
display time in 12 hour format | Excel Worksheet Functions | |||
time diffrence with 24 hour clock | Excel Worksheet Functions |