# Excel 2007 : average speed

1. ## average speed

hi all,

I am hoping that some one can help me,
I am using to excel 2007 to record my bike rides
and have it set up like;

Column A- is the date,
Column B- is the distance,
Column C- is the time,
Column D -is the route,
Column E- is the total kms
Column F -is the name of the bike,
Column G- is the total time

but I want to add another column to show my average speed
but do not know how to do this!

Hope someone can help

Ian

2. ## Re: average speed

Hi Ian, thanks for updating your title.

Isn't average speed simply distance / time? I'm not sure why you have two distance columns and two time columns, though. Can you explain that a little better as to what you want calculated, or better yet, post an example worksheet showing which columns are relevant?

Thanks.

3. ## Re: average speed

Originally Posted by Paul
Hi Ian, thanks for updating your title.

Isn't average speed simply distance / time? I'm not sure why you have two distance columns and two time columns, though. Can you explain that a little better as to what you want calculated, or better yet, post an example worksheet showing which columns are relevant?

Thanks.
hi paul,
I have taken a photo of the worksheet, but do not know how to make it smaller it is (12.1 kb) and the forum's limit is 10 kb so I will try to explain as best as I can,

I have two columns for distance as I want one to be the
distance of each ride, & the other to be the total kms distance for the month
but would also like to see my average speed for each ride .

4. ## Re: average speed

You can attach a workbook much larger than that.

5. ## Re: average speed

Originally Posted by shg
You can attach a workbook much larger than that.
I got it to upload o.k. this time!

Ian

6. ## Re: average speed

Hi Ian,

To calculate the average for each ride, use the following formula (this example would be for the first row of data in your example sheet (row 3):

=B3/(C3*24)

This is actually a shortened version of the formula you could use, but I reduced it since that's what you'd do mathematically anyway (=(B3*60)/(C3*24*60), but the 60 in the numerator and denominator cancel each other out).

To calculate the total for the month, use the same format but reference your total kms and total time cells:

=G3/(H3*24)

7. ## Re: average speed

Thanks Paul,

But I think I have done wrong some where as you can see!

Ian

8. ## Re: average speed

ianmark,

Please don't quote whole posts. It just clutters the forum.

Ian

11. ## Re: average speed

thanks a lot for doing that Paul,

I understand it now!

Thank you

Ian

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1