Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Calculate kilometres per hour

  1. #1
    Guest

    Default

    Hi,
    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

    Norman

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

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

    =(F7*24)*F6

    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
  •