We've partnered up with Nixers.com to offer a space where you can talk directly to Peter from Nixers.com and get an exclusive Boards.ie discount code for a free job listing. If you are recruiting or know anyone else who is please check out the forum here.

# Calculation

• 26-07-2011 7:06pm
Registered Users Posts: 10,917 ✭✭✭✭

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:

• Moderators, Motoring & Transport Moderators Posts: 23,146 Mod ✭✭✭✭

I get 25.5km/h roughly...

• Closed Accounts Posts: 20,298 ✭✭✭✭

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

• Moderators, Motoring & Transport Moderators Posts: 23,146 Mod ✭✭✭✭

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.

• Registered Users Posts: 10,917 ✭✭✭✭

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?

• Moderators, Motoring & Transport Moderators Posts: 23,146 Mod ✭✭✭✭

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

• Closed Accounts Posts: 20,298 ✭✭✭✭

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

• Closed Accounts Posts: 20,298 ✭✭✭✭

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........

• Moderators, Motoring & Transport Moderators Posts: 23,146 Mod ✭✭✭✭

Jawgap wrote: »
FAIL!!!!

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

Bastard:P

• Registered Users Posts: 1,315

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

• Registered Users Posts: 3,561 ✭✭✭

Or just use THIS

• Registered Users Posts: 10,917 ✭✭✭✭

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

• Registered Users Posts: 661 ✭✭✭

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:
the average speed then would be 34.29 km/h

hth,
andy

• Closed Accounts Posts: 20,298 ✭✭✭✭

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

• Registered Users Posts: 15,832 ✭✭✭✭

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

No. Helmets are compulsory.

• Registered Users Posts: 10,917 ✭✭✭✭

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

• Moderators, Sports Moderators Posts: 42,349 Mod ✭✭✭✭

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.

• Registered Users Posts: 5,414 ✭✭✭

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

• Registered Users Posts: 12,699 ✭✭✭✭

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