+ Reply to Thread
Results 1 to 3 of 3

Average speed of competitors

  1. #1
    Registered User
    Join Date
    10-11-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    2

    Average speed of competitors

    I have a time (1:08:31) that it took to travel 35km. How can I calculate the average speed of this competitors plus a number of others who recorded faster or slower time?
    I managed to convert the time to seconds but when I load a simple formula to convert to KPH it never works.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Average speed of competitors

    Hi, and welcome to the forum

    =35/(A1*24)
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    10-11-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Average speed of competitors

    Excellent. It worked. Thank you Richard.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Average Speed need...
    By rameshs12251984 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-06-2013, 09:31 AM
  2. Excel 2007 : average speed
    By ianmark in forum Excel General
    Replies: 10
    Last Post: 07-19-2009, 12:20 AM
  3. [SOLVED] average speed?
    By William Stokes in forum Excel General
    Replies: 3
    Last Post: 06-05-2006, 08:35 AM
  4. Calculate average speed
    By 41db14 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-15-2006, 02:55 PM
  5. [SOLVED] average speed
    By Rob in forum Excel General
    Replies: 2
    Last Post: 01-08-2006, 03:00 PM

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