You can NOT enter times in without a colon and have Excel automatically
recognize them as times. If you do that, then you need a helper column with a
formula that translates the number into a true time, OR your need to use a VBA
macro to do that. If you are a "beginner" with Excel, I would go with a
formula.

Here's one possible formula. Assuming the time is in C2:

=TIME(INT(C2/100),MOD(C2,100),0)

On Mon, 7 Mar 2005 08:21:03 -0800, Jan wrote:

I read some of the posts and found out I can enter times without a colon in
military format, but I did not understand the answer and would like another
explanation in beginner terms please. Thank you.