Results 1 to 4 of 4

Thread: speed(the distance kind)

  1. #1
    Seeker joseph66's Avatar
    Join Date
    Oct 2017
    Location
    South Wales
    Posts
    8
    Articles
    0
    Excel Version
    2013

    Question speed(the distance kind)



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello All I need help I am trying to work out a speed in km/hour. However, some of the speeds are slow, for example, 2.06 km covered in 24 minutes and 23 seconds. I have tried diving distance by speed but I am getting rubbish results.Please help as doing this as part of weight loss program set by doctor and trying to get as much information as I can.

  2. #2
    Conjurer Logit's Avatar
    Join Date
    Nov 2016
    Posts
    225
    Articles
    0
    Excel Version
    2007
    .


    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    1
    Distance
    Time
    KPH
    2
    2.06
    00:24:23
    5.0690
    <<<---
    =A2/(B2*24)
    3
    4
    https://www.extendoffice.com/documen...-and-time.html
    5
    6
    7
    2.06 km covered in 24 minutes and 23 seconds.

  3. #3
    Seeker joseph66's Avatar
    Join Date
    Oct 2017
    Location
    South Wales
    Posts
    8
    Articles
    0
    Excel Version
    2013
    Thanks forgot the other part the 824 remembered the equation S=Distance/Time but could not compensate for an hour, thanks!!!

  4. #4
    Conjurer Logit's Avatar
    Join Date
    Nov 2016
    Posts
    225
    Articles
    0
    Excel Version
    2007
    You are welcome.

Tags for this Thread

Posting Permissions

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