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.