MacB
Lover of things that come in 3's
- Location
- Farnborough, Hampshire
In case anyone needs it, this has been bugging me for a while. I wanted to be able to enter my ride times in traditional format, HH:MM:SS and then have excel work out avg speed based on distance, up to now I used a workaround. However this works:-
=ROUND((Distance/(Time*86400))*3600, 2)
You need to make sure the cells are formatted correctly
=ROUND((Distance/(Time*86400))*3600, 2)
You need to make sure the cells are formatted correctly