+ Reply to Thread
Results 1 to 11 of 11

Excel 2007 : average speed

  1. #1
    Registered User
    Join Date
    07-18-2009
    Location
    vic,aus
    MS-Off Ver
    Excel 2010
    Posts
    11

    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
    Last edited by ianmark; 07-18-2009 at 01:37 AM. Reason: title

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    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. #3
    Registered User
    Join Date
    07-18-2009
    Location
    vic,aus
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: average speed

    Quote Originally Posted by Paul View Post
    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,
    thanks for your email,
    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. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: average speed

    You can attach a workbook much larger than that.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    07-18-2009
    Location
    vic,aus
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: average speed

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

    Ian
    Attached Files Attached Files

  6. #6
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    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. #7
    Registered User
    Join Date
    07-18-2009
    Location
    vic,aus
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: average speed

    Thanks Paul,

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

    Ian
    Attached Files Attached Files
    Last edited by shg; 07-18-2009 at 10:35 PM. Reason: deleted spurious quote

  8. #8
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: average speed

    ianmark,

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

  9. #9
    Registered User
    Join Date
    07-18-2009
    Location
    vic,aus
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: average speed

    sorry about that!

    Ian

  10. #10
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: average speed

    Not sure what problems you had, but here's your file with the new formulas added in.
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    07-18-2009
    Location
    vic,aus
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: average speed

    thanks a lot for doing that Paul,

    I understand it now!

    Thank you

    Ian

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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