So I got:

=IF(AND($H63>=TIMEVALUE(LEFT($J$62,5)),TIMEVALUE(RIGHT($J$62,5))>=$H63),1,0)

to work for 06:00-14:30, but it doesn't work for 20:00-04:30. I feel like there is some simple condition test that would enable this to work both ways. But I can't quite get there.

Again, thanks for any help!

Regards,

jpickral