Using IF and AND to find a number

[semper5]

I am looking for a formulas to Look at the start time and end time, compare it to the times listed, and if the times are as reflected, to put a "1" in the box, and nothing if it doesn't fit. I was using the following:

=IF(ISERROR(INT(IF(AND(L2>=$G$6,L2<=$H$6),1,0))),"0",INT(IF(AND(L2>=$G$6,L2<=$H$6),1,0)))

But I am wondering if I am complicating things? It works, but it is so long, and difficult to copy down, I'm thinking there may be a more efficient way.

Would you be willing to look at this?

Thanks!

 

[bosco_yip]

See attached file

Regards

 

[semper5]

Thank you Bosco_yip. Sometimes I tend to complicate things so much...