Cycling Speed Calculator

[pujo]

Morning all.
I am trying to create a cycling calculator in excel for average speed.
On this site, there is the "Average Speed Calculator, how can I recreate it in excel?
I know the distance in miles ex. 100 and time 04:39:02.50 (hh:mm:ss.ms)
looking for the average speed. Thanks!

http://www.machinehead-software.co.uk/bike/speed_distance_time_calc.html

 

[Fluff]

How about

Excel 2013/2016
	A	B	C
1	Miles	Time	Avg
2	100	04:39:03	21.502
List

Cell Formulas
Range	Formula
C2	=A2/(B2*24)

 

[pujo]

Awesome and simple!
Thanks for the quick response!
Cheers!

 

[Fluff]

You're welcome