A2B224 into a blank cell where you want to output the result and then drag the fill handle down to the cells you want to get all results see screenshot. If the distance was 300 kilometers and it took you 5 hours to cover it your speed was 300 5 60 kmh kilometers per hour. Now find the total distance traveled.
To work out speed divide the distance of the journey by the time it took to travel so speed distance divided by time.
Distance Speed. In our example 100 miles2 hours 50 mileshour about 80 kilometershour. To solve for speed or rate use the formula for speed s dt which means speed equals distance divided by time. Calculate average speed of a moving object from the total distance travelled and the time taken from start to finish.