Not very elegant, perhaps someone will improve upon it.
For columns D:E =IF(OR($A6>=$B$2,$B6<=$A$2),"no overlap",IF(D$5="Start overlap time",MAX(A$2,A6),MIN(A$2,A6)))
For column J: =IF(AND(G6<H6,G6>=H$2,H6<=G$2),"no overlap",IF(OR(G6>G$2,G6<H$2),G6,IF(OR(H6>G$2,H6<H$2,AND(G6<=G$2,H6>=H$2)),G$2)))
For column K: =IF(J6="no overlap","no overlap",IF(OR(H6>G$2,H6<H$2),H6,IF(AND(G6<=G$2,H6>=H$2),H$2,H$2)))
Let us know if you have any questions.
Bookmarks