An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
I assume you have Distance and Time take. If so the formula would be:
=(60/(C3*1440))*B3
Where:
C3 = time taken (in true time format)
1440 = Minutes in one day, multiplied by time formta converts minutes to decimal format
B3 = Distance
So as an example:
5 Km in 10 minutes - mental arithmetic says 10 minutes for 5 km therefore multiply by 60/10 to work out how far in an hour = 30
=(60/(00:10*1440))*5 = 30 KPH
If you then have multiple lines for which you want the average, use the AVERAGE function with the range of speeds.
Thanks
Rob H