Time-Based Conditional Formatting With Offset

Hello,
I’m needing to conditionally format a cell to highlight for a segment of time. Using the code attached I created a macro that displays a clock on the sheet. Using the clock and conditional formatting I was able to get cells to highlight for a period of time. That was yesterday. Today I again used the clock reading and conditional formatting >>> new rule >>> use a formula… >>> = TIME (xx,xx,xx)<(Clock Cell)< TIME(yy,yy,yy) but today it is not working for some reason and I’m wondering if you can help me out. Thanks !

= and(TIME (xx,xx,xx)<(Clock Cell),(Clock Cell)< TIME(yy,yy,yy))
and
with your code i've got date and time