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:

Please Login or Register  to view this content.

Please also see the image associated with this:

Thanks!
btorrean

[PeterB]

Try this modified version:

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

(What you appeared to be doing wrong is not accounting for the fact that 00:15 is not greater than a time before 24:00 - hence the changes given above.)