Find text and return the cell to the right in the same row

[bnbrilhart]

I am working on a spreadsheet looking a different timestamp data.
For each record there are multiple and varying locations that the timestamps can originate and end. Some go A to B and some B to A but there are like 50 possibilities.
EX:
name loc 1 time 1 loc 2 time 2 loc 3 time 3
Joe A 12:00 B 1:00 C 1:20
Bob B 3:00 F 3:15 C 4:00
Sue A 5:00 B 9:00 G 9:15


I am trying to figure out a way to add another column next to this table to only depict what time they were in location B.

Thank you for any help!

 

[V_Malkoti]

This worked for me:
=INDEX(B2:G2, 1,MATCH("B", B2:G2, 0)+1)

where my data table is in columns A:G with name in A, loc1 in B, time1 in C and so on...

 

[bnbrilhart]

That is exactly what I needed! Thank you!!!