Use formula to get "B" Break Time for each agent in the first column

Question

enter image description here

I want to know the correct function to use here to get the break for each agent

Answer 1

try in row 7:

 =INDEX(TRIM(FLATTEN(QUERY(TRANSPOSE(IF(E7:R="B"; E6:P6; ));;9^9))))

Answer 2

Paste this formula in A7

=IFERROR(INDEX($E$6:$Q$6,1,ArrayFormula(MATCH(1,SEARCH("B",E7:NQ7),0))),"No Break")