Tags: NOW

Validate cell to accept current time

{0 Comments}

To enable a person to enter current time in a cell, enter the following formula in Data > Validation > Custom

=ABS(A1-(NOW()-INT(NOW())))<(1/(60*24))

In this validated cell now, a person can enter time either by pressing Ctrl+Shift+; or by simply typing in the time entry.  The validation rule is such that it will accept only time which is within a minute of current time.  Change the 1 in the formula to change the 1 minute logic.