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!
=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!