| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
default time to PM after 12:00 pm
Currently Excel defaults to AM when entering a time. Does anyone know if I
can make default to PM when entering a time I know should be after 12:00pm? I can't figure out how I can let Excel know I mean 1:00 PM rather than 1:00 AM without typing in the PM. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
default time to PM after 12:00 pm
Hi,
use the 24hr clock and enter 01:00 PM as 13:00 Mike "default time to PM after 12:00 pm" wrote: Currently Excel defaults to AM when entering a time. Does anyone know if I can make default to PM when entering a time I know should be after 12:00pm? I can't figure out how I can let Excel know I mean 1:00 PM rather than 1:00 AM without typing in the PM. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
default time to PM after 12:00 pm
Thanks Mike. I'm concerned about the users entering military time.
"Mike H" wrote: Hi, use the 24hr clock and enter 01:00 PM as 13:00 Mike "default time to PM after 12:00 pm" wrote: Currently Excel defaults to AM when entering a time. Does anyone know if I can make default to PM when entering a time I know should be after 12:00pm? I can't figure out how I can let Excel know I mean 1:00 PM rather than 1:00 AM without typing in the PM. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
default time to PM after 12:00 pm
I don't know how to change the default...
You can however type 1 P to get 1:00 PM or type 13:00? or you can enter the values in a helper column and have a formula adding 12 hours in your main column... "default time to PM after 12:00 pm" wrote: Currently Excel defaults to AM when entering a time. Does anyone know if I can make default to PM when entering a time I know should be after 12:00pm? I can't figure out how I can let Excel know I mean 1:00 PM rather than 1:00 AM without typing in the PM. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
default time to PM after 12:00 pm
Hi,
You have 2 choices military time or AM/PM. If you simply enter 01:00 without an AM/PM qualification then Excel can't know what you mean so will assume AM Mike Mike "default time to PM after 12:00 pm" wrote: Thanks Mike. I'm concerned about the users entering military time. "Mike H" wrote: Hi, use the 24hr clock and enter 01:00 PM as 13:00 Mike "default time to PM after 12:00 pm" wrote: Currently Excel defaults to AM when entering a time. Does anyone know if I can make default to PM when entering a time I know should be after 12:00pm? I can't figure out how I can let Excel know I mean 1:00 PM rather than 1:00 AM without typing in the PM. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time format shows default of 12:00 AM | Excel Worksheet Functions | |||
| Default date and time in the comment. | Excel Worksheet Functions | |||
| HOW DO YOU SET THE DEFAULT TIME FOR DATE IN EXCEL TO 8:00 AM? | Excel Discussion (Misc queries) | |||
| Problem with default date/Time | Excel Worksheet Functions | |||
| Default Time | Excel Discussion (Misc queries) | |||
Linear Mode
