I would like to know if there is any way to calculate travel duration in past time in Bing API. I have been using your model for some time, but suddenly, the results for different modes of transport (transit/walking/driving) are the same. the statement of understanding and truth in expert reports for the CJS in England and Wales, as required in the Criminal Practice Directions V 19B (section 37.2.2) and Criminal Practice Directions . 0. First - I'm relatively new to Power BI. My old file no longer functions except for the calculations due to web services and the like changing over the years. Instead of start and end. For the Microsoft API insert "&distanceUnit=mi" into the Distance Lookup URL, Good suggestion Chris. It's Really Helpful. JavaScript is disabled. Follow the steps: Go to the DEVELOPER ribbon and add select Visual Basic a and new Module to your VBA Project, Insert the code from sections above (notice that the function is Public therefore will be visible in your workbook as a so called UDF (User Defined Function). By Using the Google Maps API, it allows for flexible addresses, zip codes and even cities giving real time driving distance and driving time directly into Excel. See the VBA code here: You can calculate the distance between two coordinates (2 pairs of latitudes and longitudes) using either Googles API or a simple VBA Function. =DistanceInMiles (E5,E6,C8) Next, press the ENTER button and you will see the distance between Ohio and Alaska in miles. I'm using the google maps solution. Your email address is private and not shared. https://maps.googleapis.com/maps/api/distancematrix/xml?origins=1,+Infinity+loop,+San+Francisco,+CA&destinations=Redmond,+Seattle,+WA&mode=driving&key=gmaps.key. I'm using the Bing Maps API. This month w What's the real definition of burnout? Am I doing something wrong? This can be a city, state, region, territory, or country. Distance formula - Excel formula | Exceljet So I knocked up quickly this VBA Function in Excel which uses Google API distance matrix function to calculate the Google Maps distance. Finding distance between two addresses in Excel Find out about what's going on in Power BI by reading blogs written by community members and product staff. In this series, we call out current holidays and give you the chance to earn the monthly SpiceQuest badge! Since it is much easier to get an API Key for Bing, i am using this alternative. How does FILTERXML() work? Dear Chandoo, However, the waypoint doesn't come up in the response: Notify me of when new comments are posted via e-mail. How do we calculate distance between 2 cities in Google Sheet? Calculate travel time and distance between two addresses using Excel + Maps API https://chandoo.org/wp/distance-between-places-excel-maps-api/ If we know the addresses, we can go to either Google Maps or Bing Maps and type them out to find the distance and travel time. The results are tab separated and can be . Currently the nice file provided is useless if your decimal separator is a comma. Thanks. After that, use the following formula to see the distance in kilometer. Any idea what the problem might be?