default time to PM after 12:00 pm

's Computer Specifications

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.

's Computer Specifications

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.

's Computer Specifications

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.

's Computer Specifications

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.

's Computer Specifications

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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Time Zone, how to default to PT Time	Joe Wildman	Microsoft Excel Worksheet Functions	5	8th Feb 2009 04:07 PM
Meeting/Appointment time and date default to current date/time	Boe	Microsoft Outlook Discussion	7	7th Dec 2007 09:20 PM
Default to time???	Bill	Microsoft Access Database Table Design	3	31st Mar 2006 02:33 PM
Outlook 2003 - how do I change the default Snooze time (default i.	=?Utf-8?B?b3hsaWQ=?=	Microsoft Outlook Discussion	1	27th Jan 2005 04:34 PM
Default TIME	Lee T.	Microsoft Access Form Coding	4	19th Feb 2004 08:23 PM