How to Calculate & Track Your Business Mileage Automatically with Google Sheets

How to set up a Google Spreadsheet to automatically calculate and keep track of your business mileage, ready for your year-end expense claim.

⭐ My Referral Links ⭐
🏎️ Schedule a FREE test drive or order Tesla Products: https://geni.us/SoN-TESLA
💡 Split £100 with me when you switch to 🐙 Octopus Energy: https://geni.us/SoN-OctopusEnergy
🧋 Get £10 off at Huel: https://geni.us/SoN-Huel
🎸 Buy musical instruments, audio & PA gear from Thomann: https://geni.us/SoN-Thomann
🌍 My KIT profile: https://kit.co/paulfp
(Commissions/credits are earned from these links, which helps support me and the channel.)

The Spreadsheet formula uses Google Maps' API to plot the driving route between the two locations and then extracts the distance driven. Copy & Paste this into the appropriate cell inside Google Sheets:

=importxml("https://maps.googleapis.com/maps/api/..." & C2 & "&destination=" & D2 & "&sensor=false&alternatives=false&key=" & API_KEY!$A$1,"//leg/distance/value")
[Change C2 and D2 to whichever cells have your start/end points in, and ensure you have a sheet called API_KEY with your API key in cell A1.]

The formula to turn the result of the above into miles is:
=ROUNDUP(CONVERT(E2, "m", "mi"), 1)
[Change E2 to whichever cell it should be referencing.]

⭐🤩 If this video has helped you, a Super Thanks would be very much appreciated! 😘😉

► Support on PATREON:   / switchedonnetwork  
► Browse our MERCH: https://teespring.com/stores/switched...
► Explore our GEAR: https://kit.co/paulfp

Check out our Amazon Influencer shops!
► UK: https://www.amazon.co.uk/shop/switche...
► USA: https://www.amazon.com/shop/switchedo...

Let's connect... ###
Twitter -   / switchedonnet  
Facebook -   / switchedonnetwork  
Instagram -   / switchedonnetwork  
Tumblr -   / switchedonnetwork  
Pinterest - https://www.pinterest.co.uk/switchedo...

Visit our website at https://www.switchedonnetwork.com/ and enable push notifications so you never miss a new video or post.

Switched On Network is hosted by Paul Freeman-Powell
► Follow Paul on Twitter:   / paulfp  
► Follow Paul on Facebook:   / paulfp  

We sometimes use free sound effects in our videos from http://www.freesfx.co.uk

Stock video clips are (usually) from VideoBlocks, now called Storyblocks Video. You can get a free trial at https://videoblocks.go2cloud.org/SHFJ

DISCLOSURE: As an Amazon Associate we earn from qualifying purchases.

Copyright © Innobella Media Limited 2018. All Rights Reserved.
https://www.innobellamedia.uk/