How to concat similar names into 1 value in single row

Hey Gurus,

I try to achieve to concat for a row.
Yellow are the row numbers and coloured gray is what I try to achieve. 
As you can see in column B, I have 2 times name “Hermiona” 2 times “Kamil” and 1 time Jacob and in column C I have their waiting time in minutes.
1. What I try to achieve is, if there matched names to have the name 1 time like in column D and have the sum up of the results which belong to that person name like in column E
2. I also try to exclude any results that are less than 15 mins waiting time like in column B6 and C6 (coloured green) 

I tried to use couple of list and concat formulas but couldn’t manage it. Any help? 

73e1e764-2d6e-431f-a3a3-1cebb4d20e46.png
0 0 82
0 REPLIES 0
Top Labels in this Space
Top Solution Authors