i'm not a developer, first of all. So please be kind to me ;-).
I created a g-doc where i can determine the distance between two adresses in kilometers. Now i would like to add the travel time too. I found a post where it states that mapquest could deliver this information with this formula:
=importXML("http://mapquestapi.com/directions/v1/route?key=YOUR_KEY_HERE&outFormat=xml&from=" & A2 & "&to=" & B2,"//response/route/formattedTime")
I created the mapqtest key, enterd it into the formula and it worked for one calculation and then never again. What am i doing wrong?
Thanks for your help!