4 ms·
You could create a table with 3 columns: distance, time, pace. Set the display format for time and pace to "Duration". Enter these formulas: distance = time
by fainpul 10mo ago
You could create a table with 3 columns: distance, time, pace.
Set the display format for time and pace to "Duration".
Enter these formulas:
distance = time / pace
time = distance * pace
pace = time / distance
Drag fill everything down. At this point you get reference errors, but once you enter any two values (thereby overwriting the formulas in those cells), you get your result.