Free Excel template · Excel for coaches and sports teams

Free playing time tracker for youth sports

For coaches who want to show every family that playing time is fair, and catch it early when it is not. Type the minutes each player played in each game. The tracker counts games played, total minutes and minutes per game, each player's share of all the minutes the team has had, and flags anyone well below a fair share. Game length and players on the field are input cells, so it works for basketball (5 on court), soccer (11, or 7 for small-sided), hockey or volleyball.

cellwise-playing-time-tracker.xlsxExcel workbook · 5.0 KB · works in Excel, Google Sheets, Numbers and LibreOffice · no signup

Download free template

Preview and try it

This is the template's sheet, calculated by the same engine as the Cellwise app. Change any number to see the formulas react before you download.

	A	B	C	D	E	F	G	H	I	J	K	L
1	Player	Game 1	Game 2	Game 3	Game 4	Game 5	Game 6	Game 7	Game 8	Games played	Total minutes	Minutes per game
2	Maya	24	22	26	20	24	23			6	139	23.2
3	Jordan	22	20	24	22	21	24			6	133	22.2
4	Ava	20		22	18	20	21			5	101	20.2
5	Leo	21	24	20	23	22	20			6	130	21.7
6	Sam	14	16	10	17	13	12			6	82	13.7
7	Priya	16	18	15	19	16	18			6	102	17
8	Eli	10	14		9	11	10			5	54	10.8
9	Noah	15	18	16	15	15	14			6	93	15.5
10	Zoe	18	19	19	16	18	17			6	107	17.8
11	Kai	8	12	9		8	9			5	46	9.2
12	Rosa	16	19	17	20	14	16			6	102	17
13	Theo	16	18	22	21	18	16			6	111	18.5
14
15	Minutes used	200	200	200	200	200	200	0	0

How the formulas work

Games played and minutes per game

L2=IF(J2=0,0,ROUND(K2/J2,1))

J2 counts the games with minutes above zero, so a game a player missed (left empty) does not drag their average down. Minutes per game is total minutes over games played. Ava missed game 2 and still averages 20.2 minutes in the games she was there for.

A fair share of minutes

Q4=ROUND(Q1*Q2/COUNTA(A2:A13),1)

A 40-minute basketball game has 5 players on court, which is 200 player-minutes to share. Split across a 12-player roster, a fair share is 16.7 minutes each. Change Q1 and Q2 for your sport and age group.

Share of the minutes available so far

M2=IF($Q$5=0,0,K2/$Q$5)

Q5 is game length times players on the field times the number of games with any minutes logged, the total the team has had to share. Each player's total over that is their share of all playing time. With 12 players, an even split would be about 8.3% each.

Flag players who need more time

N2=IF(J2=0,"",IF(L2<$Q$4*$Q$6,"Needs minutes",""))

A player is flagged when their minutes per game fall below a share of the fair number. With Q6 at 60%, the line is 10.0 minutes, so Kai (9.2) is flagged and Eli (10.8) is just over the line. Raise Q6 to tighten the rule. Players who have not played yet stay blank rather than flagged.

Make it yours

Leave a game empty for a player who was absent, and type 0 only for a player who was there but did not get on. COUNTIF(">0") counts games played, so an absence does not lower their average.
Fill in minutes straight after the game, while the bench sheet is in front of you. A week later nobody remembers who played the third quarter.
Many youth leagues have a minimum playing-time rule. Put that rule's number into the sheet (as a share in Q6) so the flag matches what your league requires.
Sort by column L before the next game to see who should start or get extra minutes.

FAQ

How do I track playing time in Excel?

One row per player and one column per game, with the minutes played in each cell. =SUM across the row gives total minutes, =COUNTIF(row,">0") counts games played and total divided by games gives minutes per game.

How many minutes should each player get?

Multiply game length by the number of players on the field and divide by your roster size. In a 40-minute game with 5 on court and 12 players, that is about 16.7 minutes each. Your league may set its own minimum.

Can I use this for soccer or hockey?

Yes. Change the game length in Q1 and the players on the field in Q2, for example 60 minutes and 11 players, or 45 and 7 for small-sided soccer. The fair share and flags update.

Functions used

Related guides

More free templates

Updated November 2, 2026