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[TABLE="width: 800, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]High Tide Minus 15 minutes[/TD]
[TD]High Tide[/TD]
[TD]High Tide Plus 15 Minutes[/TD]
[TD][/TD]
[TD]Recorded time[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]=B2-15/1440[/TD]
[TD]13:25[/TD]
[TD]=B2+15/1440[/TD]
[TD][/TD]
[TD]13:20[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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.