Hello. I’m trying to create a database for cycling events, and results.
The current spreadsheet I’m using has:
Cell A2 Distance 294.00 km (formatted as text “@ km” user defined)
Cell A3 Time (7,7,59)" (formatted as Time “[HH]:MM:SS.00” user defined) data entered as “=TIME(7,7,59)”
Cell A4 Speed in Km/h - can’t understand how to do this unfortunately.
Any help appreciated. Thank you.