Format cell as military time

JE,

I appreciate the info but I am not familiar with how to set this up. Where
do I need to paste that code in my worksheet to make it work?

Thanks...
Mike

"JE McGimpsey" wrote:

> Note that US/NATO military times do not use colons.
>
> To do what you're asking, see
>
> http://cpearson.com/excel/datetimeentry.htm
>
>
>
> In article <758BFDF0-8988-463D-B92B-6B7ED22AC7DF@microsoft.com>,
> Mike <Mike@discussions.microsoft.com> wrote:
>
> > I want to type in 0700 in a cell and press <tab> to go to the next cell and
> > it will auto format it like 07:00 (military time). ex: type in 1400 and it
> > display as 14:00, etc. In other words, I want to be lazy and not have to type
> > the colon. How do I need to format the cell?
> > Thanks... Mike
>

See

http://www.mvps.org/dmcritchie/excel/getstarted.htm

In article <57591D1F-45E7-4A61-9383-2AD0C48E4C97@microsoft.com>,
Mike <Mike@discussions.microsoft.com> wrote:

> I appreciate the info but I am not familiar with how to set this up. Where
> do I need to paste that code in my worksheet to make it work?

Copy the second lot of code from Chip's site.

Right-click on your sheet tab and "View Code"

Paste into that sheet module.


Gord Dibben MS Excel MVP


On Mon, 17 Jul 2006 13:16:01 -0700, Mike <Mike@discussions.microsoft.com> wrote:

>JE,
>
>I appreciate the info but I am not familiar with how to set this up. Where
>do I need to paste that code in my worksheet to make it work?
>
>Thanks...
>Mike
>
>"JE McGimpsey" wrote:
>
>> Note that US/NATO military times do not use colons.
>>
>> To do what you're asking, see
>>
>> http://cpearson.com/excel/datetimeentry.htm
>>
>>
>>
>> In article <758BFDF0-8988-463D-B92B-6B7ED22AC7DF@microsoft.com>,
>> Mike <Mike@discussions.microsoft.com> wrote:
>>
>> > I want to type in 0700 in a cell and press <tab> to go to the next cell and
>> > it will auto format it like 07:00 (military time). ex: type in 1400 and it
>> > display as 14:00, etc. In other words, I want to be lazy and not have to type
>> > the colon. How do I need to format the cell?
>> > Thanks... Mike
>>

Copy the second lot of code from Chip's site.

Right-click on your sheet tab and "View Code"

Paste into that sheet module.


Gord Dibben MS Excel MVP


On Mon, 17 Jul 2006 13:16:01 -0700, Mike <Mike@discussions.microsoft.com> wrote:

>JE,
>
>I appreciate the info but I am not familiar with how to set this up. Where
>do I need to paste that code in my worksheet to make it work?
>
>Thanks...
>Mike
>
>"JE McGimpsey" wrote:
>
>> Note that US/NATO military times do not use colons.
>>
>> To do what you're asking, see
>>
>> http://cpearson.com/excel/datetimeentry.htm
>>
>>
>>
>> In article <758BFDF0-8988-463D-B92B-6B7ED22AC7DF@microsoft.com>,
>> Mike <Mike@discussions.microsoft.com> wrote:
>>
>> > I want to type in 0700 in a cell and press <tab> to go to the next cell and
>> > it will auto format it like 07:00 (military time). ex: type in 1400 and it
>> > display as 14:00, etc. In other words, I want to be lazy and not have to type
>> > the colon. How do I need to format the cell?
>> > Thanks... Mike
>>

Thanks a million to all - this works perfect.
Mike

"Gord Dibben" wrote:

> Copy the second lot of code from Chip's site.
>
> Right-click on your sheet tab and "View Code"
>
> Paste into that sheet module.
>
>
> Gord Dibben MS Excel MVP
>
>
> On Mon, 17 Jul 2006 13:16:01 -0700, Mike <Mike@discussions.microsoft.com> wrote:
>
> >JE,
> >
> >I appreciate the info but I am not familiar with how to set this up. Where
> >do I need to paste that code in my worksheet to make it work?
> >
> >Thanks...
> >Mike
> >
> >"JE McGimpsey" wrote:
> >
> >> Note that US/NATO military times do not use colons.
> >>
> >> To do what you're asking, see
> >>
> >> http://cpearson.com/excel/datetimeentry.htm
> >>
> >>
> >>
> >> In article <758BFDF0-8988-463D-B92B-6B7ED22AC7DF@microsoft.com>,
> >> Mike <Mike@discussions.microsoft.com> wrote:
> >>
> >> > I want to type in 0700 in a cell and press <tab> to go to the next cell and
> >> > it will auto format it like 07:00 (military time). ex: type in 1400 and it
> >> > display as 14:00, etc. In other words, I want to be lazy and not have to type
> >> > the colon. How do I need to format the cell?
> >> > Thanks... Mike
> >>
>
>

Copy the second lot of code from Chip's site.

Right-click on your sheet tab and "View Code"

Paste into that sheet module.


Gord Dibben MS Excel MVP


On Mon, 17 Jul 2006 13:16:01 -0700, Mike <Mike@discussions.microsoft.com> wrote:

>JE,
>
>I appreciate the info but I am not familiar with how to set this up. Where
>do I need to paste that code in my worksheet to make it work?
>
>Thanks...
>Mike
>
>"JE McGimpsey" wrote:
>
>> Note that US/NATO military times do not use colons.
>>
>> To do what you're asking, see
>>
>> http://cpearson.com/excel/datetimeentry.htm
>>
>>
>>
>> In article <758BFDF0-8988-463D-B92B-6B7ED22AC7DF@microsoft.com>,
>> Mike <Mike@discussions.microsoft.com> wrote:
>>
>> > I want to type in 0700 in a cell and press <tab> to go to the next cell and
>> > it will auto format it like 07:00 (military time). ex: type in 1400 and it
>> > display as 14:00, etc. In other words, I want to be lazy and not have to type
>> > the colon. How do I need to format the cell?
>> > Thanks... Mike
>>

Copy the second lot of code from Chip's site.

Right-click on your sheet tab and "View Code"

Paste into that sheet module.


Gord Dibben MS Excel MVP


On Mon, 17 Jul 2006 13:16:01 -0700, Mike <Mike@discussions.microsoft.com> wrote:

>JE,
>
>I appreciate the info but I am not familiar with how to set this up. Where
>do I need to paste that code in my worksheet to make it work?
>
>Thanks...
>Mike
>
>"JE McGimpsey" wrote:
>
>> Note that US/NATO military times do not use colons.
>>
>> To do what you're asking, see
>>
>> http://cpearson.com/excel/datetimeentry.htm
>>
>>
>>
>> In article <758BFDF0-8988-463D-B92B-6B7ED22AC7DF@microsoft.com>,
>> Mike <Mike@discussions.microsoft.com> wrote:
>>
>> > I want to type in 0700 in a cell and press <tab> to go to the next cell and
>> > it will auto format it like 07:00 (military time). ex: type in 1400 and it
>> > display as 14:00, etc. In other words, I want to be lazy and not have to type
>> > the colon. How do I need to format the cell?
>> > Thanks... Mike
>>