Help with formula time frame

[GenAkaman]

At a daycare 8:00 AM cell V208 is the start time and 6:00 PM cell W208 is the end time. First shift starts at 8 am (AV2) and ends at 6 pm (AW2). I need a 1 if this providers hours are within first shift or a 0 if not. here is my current formula. It is giving me a 0 when I should have a yes. =IF(AND(V208<=$AV$2,W208>=$AW$2),1,0)+IF(W208<V208,1,0). Some time frames will cross midnight.

 

[Jeffrey Mahoney]

How about this?

Book2
	V	W	X
207	Start Time	End Time
208	8:00 AM	6:00 PM	0
209	6:00 PM	2:00 AM	1
Sheet3

Cell Formulas
Range	Formula
X208:X209	X208	=LET(SE,IF(ShiftEnd1<ShiftStart1,1+ShiftEnd1,ShiftEnd1),ET,IF(W208<V208,1+W208,W208),IF(AND(V208<SE,ET>ShiftStart1),1,0))

Named Ranges
Name	Refers To	Cells
ShiftEnd1	=Sheet3!$AW$2	X208:X209
ShiftStart1	=Sheet3!$AV$2	X208:X209

Book2
	AV	AW
1	Shift Start	Shift End
2	6:00 PM	2:00 AM
Sheet3

 

[Jeffrey Mahoney]

BTW, welcome to the forum

 

[GenAkaman]

Thanks for the warm welcome! This formula is not working for me and I would really like to make the current formula that I have work, if possible. =IF(AND(V208<=$AV$2,W208>=$AW$2),1,0)+IF(W208<V208,1,0)
I only receive the wrong answer when this portion of the formula brings about two true ifs =IF(AND(V208<=$AV$2,W208>=$AW$2),1,0) and a false for this portion + IF(W208<V208,1,0) the final answer will be false. OR the formula brings about two false ifs =IF(AND(V208<=$AV$2,W208>=$AW$2),1,0) and a true for this portion + IF(W208<V208,1,0) the final answer will be true.
I also need to account for when time crosses 1am for some reason the current formula works for 12am -12:59am.