Format cell as military time

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

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 <[email protected]>,
Mike <[email protected]> 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

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 <[email protected]>,
> Mike <[email protected]> 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
>

If your goal is to be lazy, why not just format the cells to military time and then type in "1 pm", "6 am", "11 pm", etc. The output would be: 13:00, 6:00, 23:00.

Personally typing 1 pm is faster than typing 1300 since your fingers toggle between numbers and letters.

If you want to have 6:00 appear at 06:00 then instead of formatting to time, go to custom and enter hh:mm into the box.

Maybe this will help

http://www.cpearson.com/excel/DateTimeEntry.htm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Mike" <[email protected]> wrote in message
news:[email protected]...
> 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 <[email protected]>,
Mike <[email protected]> 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?

This works for smart as well as lazy people:

http://tinyurl.com/r3ngw

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mike" <[email protected]> wrote in message
news:[email protected]...
>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 <[email protected]> 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 <[email protected]>,
>> Mike <[email protected]> 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 <[email protected]> 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 <[email protected]>,
>> Mike <[email protected]> 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
>>

However, note that this will also implement the same AutoCorrect in Word
and other Office apps, too.

In article <[email protected]>,
"Ragdyer" <[email protected]> wrote:

> This works for smart as well as lazy people:
>
> http://tinyurl.com/r3ngw

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 <[email protected]> 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 <[email protected]>,
>> Mike <[email protected]> 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
>>

However, note that this will also implement the same AutoCorrect in Word
and other Office apps, too.

In article <[email protected]>,
"Ragdyer" <[email protected]> wrote:

> This works for smart as well as lazy people:
>
> http://tinyurl.com/r3ngw

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 <[email protected]> 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 <[email protected]>,
>> Mike <[email protected]> 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
>>

However, note that this will also implement the same AutoCorrect in Word
and other Office apps, too.

In article <[email protected]>,
"Ragdyer" <[email protected]> wrote:

> This works for smart as well as lazy people:
>
> http://tinyurl.com/r3ngw

True, but can't beat it for timecard entry on a Monday morning.

The girls reverse it after they're done.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JE McGimpsey" <[email protected]> wrote in message
news:[email protected]...
> However, note that this will also implement the same AutoCorrect in Word
> and other Office apps, too.
>
> In article <[email protected]>,
> "Ragdyer" <[email protected]> wrote:
>
>> This works for smart as well as lazy people:
>>
>> http://tinyurl.com/r3ngw

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 <[email protected]> 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 <[email protected]>,
> >> Mike <[email protected]> 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
> >>
>
>