I have a little Excel file to use transcribing some old paper data

The field is a 4 digit number representing a 24 hour moment
0522 would be 5:22 am.
all I want to enter is they 4 digit number

Many entries would be the same, as the entries all happened in the same
minute
so what I'd like to do, is...
If I leave the field blank, it would fill itself with the time put into the
field above it.
All the fields in the column are 4 digit
I tried to do a =if B4=0, " " then B5=B6

I'm missing something as I haven't done that much with Excel yet.

Please and thank you.

--


-----------------------------------------------------
2400 Baud makes you want to get out and push!!
-----------------------------------------------------

Bill H. in Chicagoland