Check if range of time falls in another range of time

That's exactly what I'm looking for! I really appreciate it :D

While testing the formula, we found out that it didn't work quite well if the "call time" exceeds the ticket start time and end time.

=IFERROR(LOOKUP(2,1/(($A$13:$A$15>=$A3)*($A$13:$A$15<$B3)+($B$13:$B$15>=$A3)*($B$13:$B$15<$B3)),A$13:A$15),"")

Ticket start/end time is absolute while the Call start/end time can vary.

(Tickets)
Start | End
12:00 | 12:05
12:22 | 12:30
12:48 | 12:55
13:10 | 13:24
13:38 | 13:44
14:05 | 14:15
15:03 | 15:10

(Calls)
Start | End | Call Type
12:03 | 12:10 | INBOUND
13:05 | 13:30 | OUTBOUND
14:05 | 14:10 | INBOUND

What we need to have is:

Start | End | | Start | End | Call Type
12:00 | 12:05 | 12:03 | 12:10 | INBOUND
12:22 | 12:30
12:48 | 12:55
13:10 | 13:24 | 13:05 | 13:30 | OUTBOUND
13:38 | 13:44
14:05 | 14:15 | 14:05 | 14:10 | INBOUND
15:03 | 15:10

While testing the formula, we found out that it didn't work quite well if the "call time" exceeds the ticket start time and end time.

=IFERROR(LOOKUP(2,1/(($A$13:$A$15>=$A3)*($A$13:$A$15<$B3)+($B$13:$B$15>=$A3)*($B$13:$B$15<$B3)),A$13:A$15),"")

Ticket start/end time is absolute while the Call start/end time can vary.

(Tickets)
Start | End
12:00 | 12:05
12:22 | 12:30
12:48 | 12:55
13:10 | 13:24
13:38 | 13:44
14:05 | 14:15
15:03 | 15:10

(Calls)
Start | End | Call Type
12:03 | 12:10 | INBOUND
13:05 | 13:30 | OUTBOUND
14:05 | 14:10 | INBOUND

What we need to have is:

Start | End | | Start | End | Call Type
12:00 | 12:05 | 12:03 | 12:10 | INBOUND
12:22 | 12:30
12:48 | 12:55
13:10 | 13:24 | 13:05 | 13:30 | OUTBOUND
13:38 | 13:44
14:05 | 14:15 | 14:05 | 14:10 | INBOUND
15:03 | 15:10

Please post your samples by attaching a workbook, posting data in the format that you have used, is messy and hard to work with.

Using the file that bebo attached in post #2

Enter this formula in C3 and fill down

=IF(LOOKUP(B3,$A$13:$A$15)=MAX(C$2:C2),"",LOOKUP(B3,$A$13:$A$15))

This one in D3

=IF(C3="","",LOOKUP(C3,$A$13:$A$15,$B$13:$B$15))

And this one in E3

=IF(D3="","",LOOKUP(D3,$A$13:$A$15,$C$13:$C$15))

That should work as long as the start times are in chronological order order with no duplicates.

This looks easier than I thought! Thanks a bunch for the help. I was able to apply it and everything now works