Time Greater then and Less then =

[Redm4n83]

Good afternoon fellow peeps.

I am struggling bit time with this one, and no amount of research online is assisting me with the correct formula

I have as follows

	A	B	C	D	E	F
1	High Tide Minus 15 minutes	High Tide	High Tide Plus 15 Minutes		Recorded time
2	=B2-15/1440	13:25	=B2+15/1440		13:20

<tbody>
</tbody>

So the formula in A2 and in C2 work perfectly fine. and give the required results.
A2 13:10
C2 13:40
All of the cells on row 2 are formatted as h:mm

What i am trying to achieve here is along the lines of this.
<e2<c2,"yes","no")
UPDATE - Grrrr it will not accept my code when i repost, multiple edits and have failed still.

chasing a formula that will say if recorded time in E2 is between the times of A2 and C2, If it is between the 2 times give a reply of "yes", and if not giving a reply of "No"
<e2<c2,"yes","no")<e2<c2,"yes","no")

I would like for a formula to show me result on recorded time. I am able to create a formula that will give a result but it does not appear to work. I have changed the "Recorded time" to see if i can get the result to change, but it always stays constant as a "No"

your assistence would be awesome.

Sorry for multiple edits, it would not accept my coding,.</e2<c2,"yes","no")<e2<c2,"yes","no")
</e2<c2,"yes","no")

 

[Aladin Akyurek]

In F2 enter:

=IF(AND(E2>=A2,E2<=C2),"yes","no")

 

[Redm4n83]

Perfect,
Thankyou, that works well.
I had the same thing but for some unknown reason it would not work, I think i was missing the = next the the <.

Thanks again.
Solved

 

[Aladin Akyurek]

Perfect,
Thankyou, that works well.
I had the same thing but for some unknown reason it would not work, I think i was missing the = next the the <.

Thanks again.
Solved

You are welcome.