Is it possible to enter a formula in a cell that if some-one by accident manually enters data in the wrong cell, and deletes the cells formula. It will re-populate in the cell automatically?? Protect the formula in the cell but also allow manual data input.

I can't protect the cell as it is a time sheet and people finish earlier and later than scheduled.

Many Thanks.