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.

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.

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.

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.

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.