Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Calculate kilometres per hour

  1. #1


    I know this is probably really simple but I an unable to do it so
    I am pleading for help.

    I have a start time, say 9am
    I have a finish time, say 10:27:15 am
    and I have a distance 54km

    I now wish to put that information into a spreadsheet
    and have it give me time and km/hr

    I have put the start and finish times in formatted the cells to
    time and just subtracted 1 from the other, easy answer = 1:27:15
    now I also have in a cell somewhere on the sheet the distance of
    that race.

    Could someone please tell me how I can have excel calculate the
    km/hr as well

    thankyou in advance


  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)



    If your time is in cell F7 and your distance in cel F6, use:


    and foramt as number

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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