Calculating time

cjknox74 · Mar 25th, 2002, 12:29 PM

I am trying to make a spreadsheet for a soccer team which will calculate total time played for each player. I have time in & time out for each of 4 quarters. I need it to calculate the total time each player played. Can you help?

Duane · Mar 25th, 2002, 12:40 PM

This can be easy, as long as you
- format the time columns with your choice of the most appropriate time format (which would most probably be mm:ss)
- when the player goes in, enter the time; when the player comes off, enter the time
- in another column, simply write formula to subtract the outtime from the intime (check that; if I recall correctly, in soccer the time starts at 0:00 and counts up to 60 minutes; so if the player when in at 02:00 and came out at 03:15; subtracting 02:00 from 03:15 would leave you with 01:15, meaning the player was on for one minute, 15 seconds)

The above is general overview. Let me know if you need step by step details...

_________________
Regards, Duane

[ This Message was edited by: Duane on 2002-03-25 11:44 ]

RubberTree · Mar 25th, 2002, 02:05 PM

I have a similar time calculation requirement except I need to return total in seconds. For example, time-in is 1:54 and time-out is 1:60. Rather than return the difference of 0:06 minutes I need to be able to return 360 seconds. Since Excel return seconds in 1 to 59 before tripping to 1 minute I can't find the answer to this problem in Help.

Aladin Akyurek · Mar 25th, 2002, 02:14 PM

Quote:

On 2002-03-25 13:05, RubberTree wrote:
I have a similar time calculation requirement except I need to return total in seconds. For example, time-in is 1:54 and time-out is 1:60. Rather than return the difference of 0:06 minutes I need to be able to return 360 seconds. Since Excel return seconds in 1 to 59 before tripping to 1 minute I can't find the answer to this problem in Help.

=(B1-A1)*86400

where A1 is 1:54 and B1 1:60.

Format the cell of this formula as General.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 25th, 2002, 12:29 PM	#1
cjknox74 New Member Join Date: Mar 2002 Posts: 1	I am trying to make a spreadsheet for a soccer team which will calculate total time played for each player. I have time in & time out for each of 4 quarters. I need it to calculate the total time each player played. Can you help?

Mar 25th, 2002, 12:40 PM	#2
Duane Board Regular Join Date: Mar 2002 Location: Toronto Posts: 173	This can be easy, as long as you - format the time columns with your choice of the most appropriate time format (which would most probably be mm:ss) - when the player goes in, enter the time; when the player comes off, enter the time - in another column, simply write formula to subtract the outtime from the intime (check that; if I recall correctly, in soccer the time starts at 0:00 and counts up to 60 minutes; so if the player when in at 02:00 and came out at 03:15; subtracting 02:00 from 03:15 would leave you with 01:15, meaning the player was on for one minute, 15 seconds) The above is general overview. Let me know if you need step by step details... _________________ Regards, Duane [ This Message was edited by: Duane on 2002-03-25 11:44 ]

Mar 25th, 2002, 02:05 PM	#3
RubberTree New Member Join Date: Mar 2002 Posts: 1	I have a similar time calculation requirement except I need to return total in seconds. For example, time-in is 1:54 and time-out is 1:60. Rather than return the difference of 0:06 minutes I need to be able to return 360 seconds. Since Excel return seconds in 1 to 59 before tripping to 1 minute I can't find the answer to this problem in Help.