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
Bookmarks