Try this:
Say times to be entered in Column E
Select E1:E10, then,
<Data <Validation,
In "Allow" window, check "custom",
In Formula box, enter:

=OR(E1=TIME(18,,),E1<=TIME(6,,))
Then <OK.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Pete" wrote in message
...
How can I restrict entry to ceels between the times of
18:00 & 06:00, this must allow 22:00 etc

This is so it covers the night shift in 24hr format

Pete