I am trying to find a formula which will automatically insert the current
time into a cell based on if there is info in another cell. In cell B48, I
have the formula =IF(C480,NOW(),""). The formula works and
displays the time, however, it keeps changing as I make other changes on the
worksheet. Is there anyway to keep it from changing times? Thanks for your
help.