I'm currently running a spread sheet that will capture the time when a
condition is met in another cell...
The problem is, whenever the cell is changed from one condition to another,
the time does not reflect the latest change; the time is still constant from
the first entry.

Is it possible to get the time to refresh everytime the cell value is
changed without having to delete the first entry?

formula I'm using...
=IF((+K9+O9+S9+W9+AA94),"Not
Eligible",IF(ISBLANK(AC9),"",IF(OR(AC9="A",AC9="D" ,AC9="NA",AC9="MSG",AC9="NIS"),IF(AD9="",NOW(),AD9 ),"")))