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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter time (12-hour clock) & have it display it?
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter time (12-hour clock) & have it display it?
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. -- David Biddulph "dlw" wrote in message ... 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 |
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 |