Swimming times in hours, minutes and seconds

[66nana]

Hi
I need assistance with Swimming times in hours, minutes and seconds. I have a small swim squad and I would like Excel to add the times in minutes and seconds for every 50 metres. Eg for 400 m swim.
Example:
Tom 47.04 49.03 51.12 54.89

It would also be advantageous to know how to subtract one time from another time.

I'd sincerely appreciate some assistance.

Many thanks.

 

[FormR]

Hi, you can simply sum the seconds and divide by the number of seconds in a day. Format the cell that contains the formula as time.

For example:

Excel 2013/2016
	A	B	C	D	E	F	G
1	Tom	47.04	49.03	51.12	54.89		00:03:22
2	Jerry	50.1	51.5	48.6	90.5		00:04:01
3
4							00:00:39
Sheet1

Cell Formulas
Range	Formula
G1	=SUM(B1:E1)/86400
G2	=SUM(B2:E2)/86400
G4	=G2-G1