I would like to achieve something whereby I have a spreadsheet such that the columns are:
- Column A - place name
- Column B - place name
- Column C - distance by road between places in columns A and B
- Column D - travel time by road between places in columns A and B
I thought it might be possible using Google Docs' spreadsheet and its 'Google' functions, but I've not found any that might do the trick.
In the end I could knock up an app to do it using the Google Maps API but would rather avoid it if I can.