Soccer player field/bench time calculation

Hi

Does the attached help.

The first thing I thought it best to do was ensure all the Player references in columns Q, C,D,J&K were all text cells. Those where they contained a letter obviously were, but those with digits were numbers. It's always best for these sorts of things if there is a consistency.

I've done the first half results for you so hopefully you can follow the formulae and do the second half. I've assumed any player never plays in more than two periods in any half. i.e. they never leave play on three occasions.