Hello everybody,

I have two times 9pm and 3am. I want to see if the current time is between these two times.

Currently I am trying to do it in this manner, which doesn't work. Is there another way without having to resort to checking if the current time is before or after Midnight?

Code:
If (TimeValue(Time) >= TimeValue(lbl9PM)) And (TimeValue(Time) < TimeValue(lbl3AM)) Then