Miles Per Hour calculation

[BradSBM]

This is a stupid question-but I want a spread sheet that i can enter miles in column a and time in column b and get an average miles/hr in column c. (the hours have to be in the format h:mm:ss) and the miles can be in number format.

 

[cherria]

Time is stored as a fraction of a day internally in Excel so if you want to divide by the number of hours, multiply the cell that contains your h:m:s time by 24 to give the number of hours.

So if miles were in A1 and time in B1, c1(miles per hour) would be =A1/(B1*24)