Identifying if a time falls between 2 specified times

[Sailingdemon]

I have a column (call it A) with different times entered into it, it is formatted as HH:MM and can be anytime of the day.

I am trying to identify a formula that will place a yes in the corresponding cell in column B if the time falls between the hours of 01:00 and 07:00.

I have tried all sorts of formulas that work well for numbers but not so well for times (only), and ideas please?

 

[Jonmo1]

Welcome to the board.

Try

=IF(AND(A2>=TIME(1,0,0),A2<=TIME(7,0,0)),"Yes","No")

If A2 is actually a DATE+TIME, then we need to extract only the time.
=IF(AND(MOD(A2,1)>=TIME(1,0,0),MOD(A2,1)<=TIME(7,0,0)),"Yes","No")

 

[Sailingdemon]

Perfect Jonmo1, works a treat! been given a little project by my boss I've managed most of it from very little knowledge (very basic Excel use previously!) I was just having issues with this last bit when working with time!
Thanks again and superquick response as well.
Simon

 

[Jonmo1]

You're welcome.