Detecting whether a time falls within a military time range

[btorrean]

Dear forum,

I'm having trouble detecting whether a user-specified time falls within a military time range. I have been trying to accomplish this with the following formula, but I keep having problems:

=IF(OR(AND(S4<=R4,S4>=Q4),AND(AND(S4>=Q4,NOT(S4<=R4)),AND(NOT(S4>=Q4),S4<=R4))),TRUE,FALSE)

Please also see the image associated with this:

Thanks!
btorrean