Hello,
I need help with the following statement:
I want to do a graphic schedule in Excel, so I was using the current formula:
=IF(AND(I2>=$C3,J2<=$D3),1," ")
Where I2 is the start time and J2 is the end time and C3 and D3 are 15 min intervals, but the problem that I'm facing is when I want to also put the break time using this formula:
=IF(AND(I2>=$E3,J2<=$F3),2," ")
Where E3 and F3 are the start and end time of the break in question
How could I combine both?