How can I know if one hour is within a range of other hours? I put the image
For example, E2 should return an Inside if B2 is in the range of C2: D2, C3: D3, E4: C4 etc. or an Outside if it does not meet the condition.
I tried this code =IF(AND(B2>=MIN(C2:C16),B2<=MAX(D2:D16)),"YES","NO") But it brings me the error #¿NOMBRE?
How you could solve it, welcome suggestions
I tried the formula in my Excel and it works perfectly, the error must be in the name of the functions. If your Excel is in Spanish try:
=SI(Y(B2>=MIN(C2:C16),B2<=MAX(D2:D16)),"YES","NO")
As mentioned and confirmed in the other answer, one of the problems is the language used by the Excel instance used by the OP.
One way to solve it is to use the formulas in Spanish. Another alternative is to install the language pack which you download from the Office site.
However, changing the language of either the formula or the Excel configuration will not be sufficient to obtain the expected result.
The specification is
For example E2 should return an Inside if B2 is in the range of C2: D2, C3: D3, E4: C4 etc or an Outside if it does not meet the condition
Unfortunately it is not clear.