Time Format...

[Guest]

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

 

[Guest]

Is there any way to accomplish this using ONLY numbers?

Thanx.

 

[Ragdyer]

Yes, if you're OK using code.

Check out this link:

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