起止時間找最大數值的最後日期 (12432)

E6:F6=LOOKUP(1,0/($B2:$B16>=$E2)/($B2:$B16<=$F2)/(MAX(($B2:$B16>=$E2)*($B2:$B16<=$F2)*$C2:$C16)=$C2:$C16),B2:B16)

另解E7:F7{=INDEX(B:B,RIGHT(MAX(IF(($B2:$B16>=$E2)*($B2:$B16<=$F2),$B2:$B16/1%+$C2:$C16/1%%+ROW(2:16))),2))