Formula help - between two times

[vharp91]

Can someone help me with a formula that will have the value "Yes" in column U if the time in column I is between 7:00 PM & 7:00 AM? For Example, in the below data set, only I9 & I10 should pull in a "Yes" into U9 & U10.

Thank you

 

[MARK858]

Try...

=IF(OR(MOD(I3,1)<=TIMEVALUE("07:00"),MOD(I3,1)>=TIMEVALUE("19:00")),"YES","")

 

[MARK858]

Please note that I have updated the formula in post 2

 

[RoryA]

Another duplicate of this thread. This one is now closed.

 

[Joe4]

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.