Quick tutorial showing you how to set up a Google Spreadsheet to automatically calculate and keep track of your business mileage, ready for your year-end expense claim. This quick tip was part of our 10 New Year’s Resolutions for Businesses, which you can watch at https://goo.gl/EnrT4R
https://goo.gl/XZdg2C – G Suite and Gmail for Business makes your email look more professional by using your website’s domain name as well as giving you access to collaborative tools like Google Docs, Google Sheets, Google Calendar and Google Drive. You can get a 14-day free trial and if you message us privately we can also give you a 20% discount code for your first year. Click: https://goo.gl/XZdg2C
The formula you’ll need for calculating the route distance in metres between your two points is:
=importxml("https://maps.googleapis.com/maps/api/directions/xml?origin=" & C2 & "&destination=" & D2 & "&sensor=false&alternatives=false&key=___YOUR_API_KEY___","//leg/distance/value")
Replace “___YOUR_API_KEY___” in the formula above with an API key from https://console.cloud.google.com/ – create a project, add a billing account ($200 free credit per month), activate Directions API and then generate credentials.
TIP: Make sure the double-quote marks are simple ones – if necessary delete and re-type!
Facebook – https://www.facebook.com/SwitchedOnNetwork/
Twitter – https://twitter.com/SwitchedOnNet
Instagram – https://www.instagram.com/switchedonnetwork/
Google+ – https://plus.google.com/112924836454795429890
YouTube Channel – https://www.youtube.com/SwitchedOnNetwork?sub_confirmation=1