Tip Printed from ExcelTip.com
Calculate Average Speed in Microsoft Excel
Enter total miles in cell A1:
10
Enter total time in cell A2:
02:00
Enter the following formula:
=A1/(A2*24)
The result = 5 miles per hour