Formula for Basketball Minutes per Game

[fireburtbusto]

I know once I see how to do this I am going to kick myself as to how simple it is, but can not figure it out.
I am wanting to calculate how many minutes per game each player play in a basketball game.

I want the Min/Gm column to sum how many minutes during the game each player played. The Clock column shows each time the game clock stops and a substitution is made.


[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD]Clock[/TD]
[TD]Min Interval[/TD]
[TD]Player[/TD]
[TD]Player[/TD]
[TD]Player[/TD]
[TD]Player[/TD]
[TD]Player[/TD]
[TD].....[/TD]
[TD]Player[/TD]
[TD]Min/Gm[/TD]
[/TR]
[TR]
[TD]18:00[/TD]
[TD]5:00[/TD]
[TD]5[/TD]
[TD]15[/TD]
[TD]24[/TD]
[TD]45[/TD]
[TD]55[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]8:30[/TD]
[/TR]
[TR]
[TD]13:00[/TD]
[TD]4:30[/TD]
[TD]5[/TD]
[TD]15[/TD]
[TD]31[/TD]
[TD]45[/TD]
[TD]55[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]9:30[/TD]
[/TR]
[TR]
[TD]8:30[/TD]
[TD]6:30[/TD]
[TD]3[/TD]
[TD]15[/TD]
[TD]31[/TD]
[TD]45[/TD]
[TD]55[/TD]
[TD][/TD]
[TD]15[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2:00[/TD]
[TD]2:00[/TD]
[TD]3[/TD]
[TD]15[/TD]
[TD]24[/TD]
[TD]42[/TD]
[TD]55[/TD]
[TD][/TD]
[TD]24[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I was thinking a SUMIF formula, but can't get it to work. Any help would be great.

 

[shg]

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][td="bgcolor:#C0C0C0"]

D​

[/td][td="bgcolor:#C0C0C0"]

E​

[/td][td="bgcolor:#C0C0C0"]

F​

[/td][td="bgcolor:#C0C0C0"]

G​

[/td][td="bgcolor:#C0C0C0"]

H​

[/td][td="bgcolor:#C0C0C0"]

I​

[/td][td="bgcolor:#C0C0C0"]

J​

[/td][td="bgcolor:#C0C0C0"]

K​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td="bgcolor:#F3F3F3"]

Clock​

[/td][td="bgcolor:#F3F3F3"]

Min Interval​

[/td][td="bgcolor:#F3F3F3"]

Player​

[/td][td="bgcolor:#F3F3F3"]

Player​

[/td][td="bgcolor:#F3F3F3"]

Player​

[/td][td="bgcolor:#F3F3F3"]

Player​

[/td][td="bgcolor:#F3F3F3"]

Player​

[/td][td="bgcolor:#F3F3F3"]

.....​

[/td][td="bgcolor:#F3F3F3"]

Player​

[/td][td="bgcolor:#F3F3F3"]

Min/Gm​

[/td][td="bgcolor:#F3F3F3"]

​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]

18:00​

[/td][td]

5:00​

[/td][td]

5​

[/td][td]

15​

[/td][td]

24​

[/td][td]

45​

[/td][td]

55​

[/td][td][/td][td]

3​

[/td][td="bgcolor:#E5E5E5"]

8:30​

[/td][td]J2: =SUMPRODUCT(($C$2:$G$5=I2) * $B$2:$B$5)[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td]

13:00​

[/td][td]

4:30​

[/td][td]

5​

[/td][td]

15​

[/td][td]

31​

[/td][td]

45​

[/td][td]

55​

[/td][td][/td][td]

5​

[/td][td="bgcolor:#E5E5E5"]

9:30​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

4​

[/td][td]

8:30​

[/td][td]

6:30​

[/td][td]

3​

[/td][td]

15​

[/td][td]

31​

[/td][td]

45​

[/td][td]

55​

[/td][td][/td][td]

15​

[/td][td="bgcolor:#E5E5E5"]

18:00​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

5​

[/td][td]

2:00​

[/td][td]

2:00​

[/td][td]

3​

[/td][td]

15​

[/td][td]

24​

[/td][td]

42​

[/td][td]

55​

[/td][td][/td][td]

24​

[/td][td="bgcolor:#E5E5E5"]

7:00​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

6​

[/td][td]

0:00​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table]

 

[fireburtbusto]

Oh my. Like I said, kicking myself. Thank you so much.

 

[shg]

You're welcome.