VitalyNagy
asked on
Time input validation in Excel
How to set a validation rule to allow input of a time within, say +/-5 min of the current system time? (I know that one can ensure that with Shift-Ctrl+:, but nonetheless. Excel 2007.
Thanks.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The advice by Byundt is preferable as it accepts the shortcut. Thank you. Now, how can I spread this Custom validation over a range of cells without typing the cell address in each new cell?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start time--> =NOW()-TIME(,5,)-TODAY()
End Time--> =NOW()+TIME(,5,)-TODAY()