Try this.
A1 enter the Distance already run in miles
A2 enter the Time in minutes to run A1
A3 enter formula = A2/A1 which yields minutes to run full mile.

- John Michl
www.JohnMichl.com/exceltips.htm

TonyM wrote:
I am trying to compile a spreadsheet that can work out my running pace, i.e.
how long it would take to run a mile based on the time taken to run a
distance entered. I know how to work this out manually but do not know how to
configure a spreadsheet to do this automaticaly.