I have a sheet that contains the distance driven and the time. These are in columns B (distance) and C (time). Calculating the average speed is simple. Sum the distance and the time and divide the total distance driven by the total time used.
But how do I calculate the minimum speed and the maximum speeds?
To give an example: My last three rides have been 45,2 km/2:10 h, 13,6 km/0:45 h and 25,5 km/1:15 h. Out of these three, the first one has the greatest average speed of 20,9 kmh and the second the lowest at 18,1 kmh. How do I show this data in a cell? Do I need a script for that? If so, what should that look like?