Time Format...

[Steven Sinclair]

I'm trying to format a range of cells so that when I enter...

1348

Excel will interpret it as 1:48pm in military time.

However, I just can't seem to locate the correct format (if it even exists).

Just want to be able to enter the time without the colon and have the system
recognize it as a 24-hour format time.

Thanx.

[Ragdyer]

See if this is good enough for you:

http://tinyurl.com/r3ngw

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Steven Sinclair" <[email protected]> wrote in
message news:[email protected]...
> I'm trying to format a range of cells so that when I enter...
>
> 1348
>
> Excel will interpret it as 1:48pm in military time.
>
> However, I just can't seem to locate the correct format (if it even
> exists).
>
> Just want to be able to enter the time without the colon and have the
> system
> recognize it as a 24-hour format time.
>
> Thanx.

[Ragdyer]

See if this is good enough for you:

http://tinyurl.com/r3ngw

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Steven Sinclair" <[email protected]> wrote in
message news:[email protected]...
> I'm trying to format a range of cells so that when I enter...
>
> 1348
>
> Excel will interpret it as 1:48pm in military time.
>
> However, I just can't seem to locate the correct format (if it even
> exists).
>
> Just want to be able to enter the time without the colon and have the
> system
> recognize it as a 24-hour format time.
>
> Thanx.

[Ragdyer]

See if this is good enough for you:

http://tinyurl.com/r3ngw

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Steven Sinclair" <[email protected]> wrote in
message news:[email protected]...
> I'm trying to format a range of cells so that when I enter...
>
> 1348
>
> Excel will interpret it as 1:48pm in military time.
>
> However, I just can't seem to locate the correct format (if it even
> exists).
>
> Just want to be able to enter the time without the colon and have the
> system
> recognize it as a 24-hour format time.
>
> Thanx.

[Steven Sinclair]

Is there any way to accomplish this using ONLY numbers?

Thanx.

"Ragdyer" wrote:

> See if this is good enough for you:
>
> http://tinyurl.com/r3ngw
>
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Steven Sinclair" <[email protected]> wrote in
> message news:[email protected]...
> > I'm trying to format a range of cells so that when I enter...
> >
> > 1348
> >
> > Excel will interpret it as 1:48pm in military time.
> >
> > However, I just can't seem to locate the correct format (if it even
> > exists).
> >
> > Just want to be able to enter the time without the colon and have the
> > system
> > recognize it as a 24-hour format time.
> >
> > Thanx.
>
>

[Ragdyer]

Yes, if you're OK using code.

Check out this link:

http://cpearson.com/excel/datetimeentry.htm

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Steven Sinclair" <[email protected]> wrote in
message news:[email protected]...
> Is there any way to accomplish this using ONLY numbers?
>
> Thanx.
>
> "Ragdyer" wrote:
>
>> See if this is good enough for you:
>>
>> http://tinyurl.com/r3ngw
>>
>> --
>> HTH,
>>
>> RD
>>
>> ---------------------------------------------------------------------------
>> Please keep all correspondence within the NewsGroup, so all may benefit !
>> ---------------------------------------------------------------------------
>> "Steven Sinclair" <[email protected]> wrote in
>> message news:[email protected]...
>> > I'm trying to format a range of cells so that when I enter...
>> >
>> > 1348
>> >
>> > Excel will interpret it as 1:48pm in military time.
>> >
>> > However, I just can't seem to locate the correct format (if it even
>> > exists).
>> >
>> > Just want to be able to enter the time without the colon and have the
>> > system
>> > recognize it as a 24-hour format time.
>> >
>> > Thanx.
>>
>>

[Ragdyer]

See if this is good enough for you:

http://tinyurl.com/r3ngw

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Steven Sinclair" <[email protected]> wrote in
message news:[email protected]...
> I'm trying to format a range of cells so that when I enter...
>
> 1348
>
> Excel will interpret it as 1:48pm in military time.
>
> However, I just can't seem to locate the correct format (if it even
> exists).
>
> Just want to be able to enter the time without the colon and have the
> system
> recognize it as a 24-hour format time.
>
> Thanx.