I made this little spreadsheet to help with figuring out what time I would be in certain places on marathon routes but it works for anything now.

To use it:

  • Type in the length in miles of the race
  • Type in the best guess for how long it’ll take to cross the start line (useful at places like London where it might take ages)
  • Type in the predicted finish time

You can then type in up to four points you’ll be spectating at, and it will generate a set of times you should expect your runner. It works on a scale of 95% to 110% of the predicted time, so the ranges will get wider as the race goes on.

Hope it’s useful!