I am trying to set up a validation on a cell that will only allow times between 9:00:00 and 22:00:00 but when I enter data into the cell which is outside of the range it does not validate the cell. I have tried validating with normal numbers and this seems not to work either. Do I have to turn on validation before this feature works or am I doing something wrong. If I have to turn it on, how do I do it?
Regards Dave
