Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #503 Apr 10, 2012 www.energyefficientbuild.com.
user midhunzone said:
how to get distance between two places via road on a spreadsheet. I tried pasting some formulas i found online but it returned errors.. pls help
----
i meant keying in location like mumbai and pune in other. the formula should link it from google maps calculate the distance and return the distance in km as answer these is one code i found but i am unable to run it..pls help
=Index(importXML("http://maps.google.com/maps?saddr="&B46&"&daddr="&C46&"&ie=UTF8&hl=en&output=mobile&f=d&btnG=Get+Directions", "/html/body"),1,4)
--------------------------------------------------------
following is a solution to the problem -- I have computed the distance in km as well as in miles
UPDATED APR-25-2015
how to get distance between two places via road on a spreadsheet. I tried pasting some formulas i found online but it returned errors.. pls help
----
i meant keying in location like mumbai and pune in other. the formula should link it from google maps calculate the distance and return the distance in km as answer these is one code i found but i am unable to run it..pls help
=Index(importXML("http://maps.google.com/maps?saddr="&B46&"&daddr="&C46&"&ie=UTF8&hl=en&output=mobile&f=d&btnG=Get+Directions", "/html/body"),1,4)
--------------------------------------------------------
following is a solution to the problem -- I have computed the distance in km as well as in miles
No comments:
Post a Comment