time counting

[kelvin_9]

hello, everyone, is there any IF statement that i can use on below time range when counting start/end time and return correct or out of range?

[TABLE="width: 500"]
<tbody>[TR]
[TD]request time[/TD]
[TD]given time[/TD]
[TD]return[/TD]
[/TR]
[TR]
[TD]09:00-18:30[/TD]
[TD]09:00-18:00[/TD]
[TD]correct[/TD]
[/TR]
[TR]
[TD]09:00-16:30[/TD]
[TD]09:00-19:00[/TD]
[TD]out of range[/TD]
[/TR]
[TR]
[TD]13:00-21:00[/TD]
[TD]12:00-21:00[/TD]
[TD]out of range[/TD]
[/TR]
</tbody>[/TABLE]

thanks in advance

 

[CyrusTheVirus]

hello, everyone, is there any IF statement that i can use on below time range when counting start/end time and return correct or out of range?

[TABLE="width: 500"]
<tbody>[TR]
[TD]request time[/TD]
[TD]given time[/TD]
[TD]return[/TD]
[/TR]
[TR]
[TD]09:00-18:30[/TD]
[TD]09:00-18:00[/TD]
[TD]correct[/TD]
[/TR]
[TR]
[TD]09:00-16:30[/TD]
[TD]09:00-19:00[/TD]
[TD]out of range[/TD]
[/TR]
[TR]
[TD]13:00-21:00[/TD]
[TD]12:00-21:00[/TD]
[TD]out of range[/TD]
[/TR]
</tbody>[/TABLE]

thanks in advance

C2:

=IF(AND(--LEFT(B2,5)>=--LEFT(A2,5),--RIGHT(B2,5)<=--RIGHT(A2,5)),"correct","out of range")

 

[mrshl9898]

Try this:


=IF(SUM(IF(LEFT(B2,5)>=LEFT(A2,5),1,0),IF(RIGHT(B2,5)<=RIGHT(A2,5),1,0))=2,"CORRECT","OUT OF RANGE")

 

[kelvin_9]

C2:

=IF(AND(--LEFT(B2,5)>=--LEFT(A2,5),--RIGHT(B2,5)<=--RIGHT(A2,5)),"correct","out of range")

this is much more prefect, thank you CryusTheVirus & mrshl9898

what if i combine with this, is it work in one cell?
=IF(OR(A5="full",A5="0"),A5,"")

thanks in advance again