Timestamp date stays 12:00:00

Originally Posted by Johfra

I have successfully found this formula:
=If (b1<>"",if(a1="",now(),a1),"")
It works BUT.....the time stays all the time to 12:00:00.

I assume the formula is in A1, and you selected the Iterative calculation option.

In that case, A1 will change only when first you clear B1 (A1 will appear blank), then you enter something into B1 (A1 should reflect the current date and time if it is formatted as m/dd/yyyy hh:mm:ss.000 or something similar).

If you are doing all that and you still have a problem, I suggest that you attach an Excel file that demonstrates the problem. The devil is in the details.