Hi

I'm struggling with this...

I have data in Col U which is Date + Time e.g. 08/08/07 7:20am

I want to copy the unique values in the range to another location subject to
the criteria Menu!I5+Time(05,59,59) and <((MenuI5+1)+Time(06,00,00))

I've copied the heading from Col U to CV1 and under that have put the
criteria above in CV2 and CV3

There's a problem with those formulas as criteria or the syntax I'm using.
If I just type the formulas with an = instead of < or they work. If I copy
and paste special as values the formulas so I get a general format number I
can make the criteria work but that doesn't help as I need this to work
formulaically with no user input.

I would appreciate some help and advice on how to make this work

Many thanks