IF AND Time Range Comparison

[barnetod]

First post so bare with me.

I am attempting to create a formula which will indicate with a simple YES or NO based on a time value falling between two different times daily.

I have searched and attempted formulas but it seems to just lock into returning NO every time.

If the time is >1700 or <0700 return YES if not return NO.<time(7,0,0),g2 TIME(17,0,0)),?YES?,?NO?)<time(7,0,0),g2="">

=IF(AND(G2<TIME(7,0,0),G2>TIME(17,0,0)),"YES","NO")

Please not for some reason half of my formula is missing.<time(7,0,0),g2><time(7,0,0),g2><time(7,0,0),g2><time(7,0,0),g2>

</time(7,0,0),g2></time(7,0,0),g2>I may be missing an OR statement.

Any help would be appreciated.

After Hours	Time
YES	06:37:00
NO	12:30:00

<tbody>
</tbody>

</time(7,0,0),g2></time(7,0,0),g2></time(7,0,0),g2>

 

[RonB1111]

Your words "If the time is >1700 or <0700 return YES if not return NO." are the opposit of the example you gave at the end. The formula below assumes the time is in cell A1 and it is based on the "words" - if you want it based on the examples, switch the < and > signs:

=IF(OR(A1 > TIME(17,0,0),A1 < TIME(7,0,0)),"Yes","No")<time(7,0,0)),"yes","no")<time(7,0,0)),"yes","no")< html="">

</time(7,0,0)),"yes","no")<time(7,0,0)),"yes","no")<>

 

[barnetod]

Thank you it worked perfectly. I have been staring at 1800 lines of data and this one thing killed my brain.