Calculation

GT_TDI_150

Hey,

I have the distance I cycle and the time it takes me to cover the distance.

how do I get my (avg) speed?

s=d/t seems to be the formula, but for my parameters 22.2km/00:52:45

I'm getting 606:eek:

Alanstrainor

I get 25.5km/h roughly...

Jawgap

GT_TDI_150 wrote: »

Hey,

I have the distance I cycle and the time it takes me to cover the distance.

how do I get my (avg) speed?

s=d/t seems to be the formula, but for my parameters 22.2km/00:52:45

I'm getting 606:eek:

Your speed is just over 25 km/h

52:45 = 0.8792 hrs

Speed = 22.2/0.8792 = 25.25 km/h

Alanstrainor

Jawgap wrote: »

Your speed is just over 25 km/h

52:45 = 0.8792 hrs

Speed = 22.2/0.8792 = 25.25 km/h

Yup that's how i got my figure.

GT_TDI_150

Jawgap wrote: »

Your speed is just over 25 km/h

52:45 = 0.8792 hrs

Speed = 22.2/0.8792 = 25.25 km/h

thanks, how did you get to that figure?

Alanstrainor

GT_TDI_150 wrote: »

thanks, how did you get to that figure?

52.45/60

You want to find it in terms of hours, so 52.45 is .87 of an hour

Jawgap

52mins and 45 seconds = 52.75mins = 52.75/60 = 0.8792hrs:)

Jawgap

Alanstrainor wrote: »

52.45/60

You want to find it in terms of hours, so 52.45 is .87 of an hour

FAIL!!!!

Although there's only 0.3 in it........

Alanstrainor

Jawgap wrote: »

FAIL!!!!

Although there's only 0.3 in it........

Bastard:P

chakattack

I thought this might be about Sean Kelly's commentating on Eurosport

thebouldwhacker

Or just use THIS

GT_TDI_150

thanks lads, I keep track of all my food intake/excersise/... on an spread sheet and wanted to add the avg speed

andy69

if u are using OpenOffice (or even Excel) to record your training, you could use this formula to calculate the average speeds...

=B1/(A1*24)

This is where the distance is in Cell B1 and the Time is in Cell A1

So, to enter times, just format the cell for 'time' (right click) and pick the '13:47:46' format. As an example then for a 100km spin you can enter:
02:55:00 as your time
100 as your distance
the average speed then would be 34.29 km/h

hth,
andy

Jawgap

Websites.........spreadsheets...........does anyone (apart from Mark Renshaw) use their head in cycling any more?

Pherekydes

Jawgap wrote: »

Websites.........spreadsheets...........does anyone (apart from Mark Renshaw) use their head in cycling any more?

No. Helmets are compulsory.

GT_TDI_150

Jawgap wrote: »

Websites.........spreadsheets...........does anyone (apart from Mark Renshaw) use their head in cycling any more?

it's for historical purposes, so I can go back and track my improvement

magicbastarder

you realise you're responding to a ten year old thread?
the OP is (by my calculations) 2.2 million km away by now, assuming he kept up that speed.

fat bloke

I hope you weren't basing your calorie intake on cycling at 600kph...
I'd like to see those Garmin numbers

dastardly00

chakattack wrote: »

I thought this might be about Sean Kelly's commentating on Eurosport

^^^
This post may be a decade old but it's still applicable