Try it like this:

=IF(OR(D5="",D5<TIME(6,30,0),D5TIME(8,0,0)),"CHEC K TIME",D5)

Hope this helps.

Pete

On Mar 31, 3:31*pm, BANJO wrote:
I'm trying to test a cell D5 which contains a time eg '07:00' to see if falls
within a time range or is blank or to print it if it is within range. Excel
indicates an error???

=if(or(D5, 06:30, D58:00), "CHECK TIME" , D5)

I've tried other simple statements, but none work! *Help!!
--
BANJO