If statement 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. In other words every value in column I that lands between the time of 7:00 PM through 7:00 AM would be flagged as 'Yes', so any that were ordered/scheduled in the hours of 7pm, 8pm, 9pm, 10pm, 11pm, 12am, 1am, 2am, 3am, 4am, 5am, & 6am up to 7am.

 

[etaf]

did you read my reply to your other post ?

If Statement Formula Help

Can someone help me with a formula that will have the value "Yes" in column T if the time in column I is between 7:00 & 19:00 (time is military). Thank you!

www.mrexcel.com

 

[Fluff]

Duplicate to: If Statement Formula Help

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.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.