AVG lap time calc

Zac · May 23rd, 2002, 11:03 AM

I'm in a cycle race.
I will have about 60 laps.
I'm going to calc the AVERAGE (the easy part)lap time but what I would like to know is;

What's the best format to use in the
60 cells to record the times?
30:55:7 (ie)?

And if for some bad fate they are issued in seconds, can I enter the seconds and it converts to min'sec"?

JayKay · May 23rd, 2002, 11:16 AM

Hi Zac

Just enter the data as hh:mm:ss and excel should recognise it and format the cells appropriately.

To convert a number of seconds to hh:mm:ss use the 'time' function. i.e. If the number of seconds to be converted is in cell A1, then in cell A2 type '=time(0,0,A1)'.

Mark W. · May 23rd, 2002, 12:18 PM

Assuming that your individual lap times are under 1 hour, format your 60 cells as...

[mm]:ss.0

Note: You can show seconds with a precision of 1/10 of a second as shown above, or 1/100 of a second using [mm]:ss.00 etc.

If your lap times are given to you as seconds only (e.g., 75 seconds) then enter them as 0:0:75. Excel will automatically convert them to proper internal time values.

[ This Message was edited by: Mark W. on 2002-05-23 11:28 ]

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

May 23rd, 2002, 11:03 AM	#1
Zac Board Regular Join Date: Feb 2002 Location: Mike Posts: 796	I'm in a cycle race. I will have about 60 laps. I'm going to calc the AVERAGE (the easy part)lap time but what I would like to know is; What's the best format to use in the 60 cells to record the times? 30:55:7 (ie)? And if for some bad fate they are issued in seconds, can I enter the seconds and it converts to min'sec"?

May 23rd, 2002, 11:16 AM	#2
JayKay New Member Join Date: May 2002 Location: Leicester, UK Posts: 40	Hi Zac Just enter the data as hh:mm:ss and excel should recognise it and format the cells appropriately. To convert a number of seconds to hh:mm:ss use the 'time' function. i.e. If the number of seconds to be converted is in cell A1, then in cell A2 type '=time(0,0,A1)'.

May 23rd, 2002, 12:18 PM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Assuming that your individual lap times are under 1 hour, format your 60 cells as... [mm]:ss.0 Note: You can show seconds with a precision of 1/10 of a second as shown above, or 1/100 of a second using [mm]:ss.00 etc. If your lap times are given to you as seconds only (e.g., 75 seconds) then enter them as 0:0:75. Excel will automatically convert them to proper internal time values. [ This Message was edited by: Mark W. on 2002-05-23 11:28 ]