取後面時間 (9177)

E4:F6=IFERROR(LOOKUP(9,--RIGHT(LOOKUP(99,FIND($D4,A$4:A$10),A$4:A$10),{3,4,5})),"")

另解=IFERROR(-LOOKUP(1,-RIGHT(LOOKUP(1,-FIND($D4,A$4:A$10),A$4:A$10),ROW($1:$9))),"")