HOW DO I DATE STAMP/TIME STAMP A INPUT FIELD BUT MAKE SURE IT DOESNT CHANGE WHEN THE NEXT ENTRY BELOW IS ENTERED EG:
A1 IS THE DATA INPUT FIELD B1 IS THE FORMULA FOR DATE AND TIME WHICH I COPY DOWN THE COLUMN
A1 DATA ENTERED B1 GIVES ME DATE AND TIME BUT WHEN A2 IS ENTERED THE TIME CHANGES NOT ONLY IN B2 BUT IN B1 TOO. ITS A BIT OF A BUGGER
MY B COLUM FORMULA IS AS FOLLOWS:
=IF(A3=",",IF(B3="",NOW(),B3),NOW())
A1 IS THE DATA INPUT FIELD B1 IS THE FORMULA FOR DATE AND TIME WHICH I COPY DOWN THE COLUMN
A1 DATA ENTERED B1 GIVES ME DATE AND TIME BUT WHEN A2 IS ENTERED THE TIME CHANGES NOT ONLY IN B2 BUT IN B1 TOO. ITS A BIT OF A BUGGER
MY B COLUM FORMULA IS AS FOLLOWS:
=IF(A3=",",IF(B3="",NOW(),B3),NOW())