Hi kvsrinivasamurthy,

My example is in post #6

So what I basically am looking for is to see which hours are covered. For example IF in A2 the word "Test" appears I want it to check the corresponding cell, in this case C3. If C3 is covering the hour 08:00-09:00 in B13 then it should show 1.

As you see in A3 there is no "Test" written but "Different" so it doesn't count it.

Problem is (at least I don't know how) that the formula will be too long if I repeat the formula 30+ times in 1 cell. it will go over the character limit.

I took IF(endTime2>startTime2,IF(AND(startTime2<=startTime1,endTime2>=endTime1),1,0),IF(AND(startTime2<=startTime1,endTime2+"24:00:00">=endTime1),1,0)) from KOKOSEK in Post: #4

I hope it's a bit more clear