Validate cell to accept current time


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


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.

Leave a Comment

Your email address will not be published.