Excel recalculates all formulas every time a change is made anywhere in the worksheet. If you want to retain the time the checkbox was ticked you will need some VBA to replace the formula with a value.