Step 4Īfter that, you should convert the results from the time format to the general format by selecting General from the drop-down list located in the Number group of the Home tab. Please check out the below screenshot for the same. Step 3Īfter that, drag the fill handle all the way down to the cells where you want the results to appear. Important Note − Please adjust the values of C2 and B2 in the formula that was just presented, these are the distance and the amount of time, respectively. Please refer to the below screenshot for the same. Simply insert this formula into a blank cell located in the area of the spreadsheet where you wish the result to appear. In the first step, let us assume we have a sample data for calculating average speed from distance and time as shown in the below screenshot for the same. Let’s understand step by step with an example. In this tutorial, we will use a simple formula to calculate the average speed based on the distance travelled and the amount of time spent doing so. However, there are situations in which the hours are not represented by numbers but rather a time format, how would you handle this work in Excel? In a typical scenario, we are able to easily calculate the average speed in an Excel worksheet by using the formula Speed = Distance / Hours.
