Okay, so I have the following:
COLUMN A COLUMN B
Person A
1 - BREAK
11:30:00 00:05:00
12:30:00 00:04:00
1 - BREAK 00:09:00
As you can see, for each Person I have a list of times that breaks were taken and the length of those breaks, followed by a total time. I essentially want to be able to pick up the total for each person. One thing to bear in mind though is that not each total is exactly four columns down (as depends on the amount breaks taken). As such, I need a formula that will allow me to search for the second instance of '1 - BREAK' after each persons name and then return the total time. I have about 20 different people's names, all different.
I've tried to do this with vlookup or a combination of offset and match/index but realise the second instance of something can't be picked up with vlookup therefore a bit lost as to what I could try next.
Is what I want to achieve actually possible?
Thanks.
Bookmarks