Calculating playing time?

[BernieMtl]

I manage a soccer team, and I keep track of each players playing time.

They play 30 minute halfs, and at the start of each half I start a stopwatch.

Thus:


Player "A" is off the field from 0:00 to 10:12
Player 'B" is then off 10:12 to 15:00
Player "C" is then off from 15:00 to 22:15

etc etc (I actually have 4-5 players off at a time, and they will be changing 6-7 times per match)

Right now I enter each period they are on the bench with a starting and end time h:mm:ss, and then total the time they are on the bench and deduct from the time of the match.

Thus:

Time on the bench (minus) time of the match (equals) time played.

The problem Is that I need to enter each as h:mm:ss...which is time consuming and prone to errors:

Is there an easier way?

 

[Dan Rittgers]

is the "stopwatch" in hundreths of hours or minutes?

Check This out

Column A Col B Col C Col D Col E Col F
Name (1st Start) (1st end) (2nd start) (2nd end) Sum of time

1) When a player starts enter this formula in the start column =now()
This is important (copy and Value this formula
2) Put the same formula =now() in 1st end but do not value it until the player is taken out of the game
3) Column f=Col B-col C+col D-col E

add columns as required and adjust the formmula "Sum of Time"

You might put the "Sum of Time" next to the player's name

Do not forget to value the formula Start immediately and when you take the player out

Hit F9 everytime you want the exact time of play for each player