Calculate Average Speed in Google Sheets

Here's how to calculate average speed in Google Sheets.  In this case, I'm calculating average miles per hour.  I rounded to minutes.

	C	D	E
2	Dist (miles)	Time	Avg MPH
3	9.58	0:50:13	11.50

Column D is formatted as Duration.  HH:MM:SS

E3=(60/((hour(D3)*60)+minute(D3)))*C3

This equation converts the duration into minutes.

The "hour" function returns the hour value in the duration. I then multiply the returned value by 60.

The "minute" function returns the minute value in the duration.

I then add both minutes from the "minute" and "hour" function to get total minutes.

Quick algebra gets you your result:

E3 60

-- == --

C3 D3

or

X 60 minutes

------------ == -------------

9.58 miles 50 minutes