Google API/distance calculator

Hello,

I am working on this new excel-sheet, that can calculate the kilometers from one place "A" to place "B".

I have found inspiration online on different forums, and I've ended up using this as the function for VBA. It works like a charm.

Please Login or Register  to view this content.

I am using "=G_DISTANCE(C2;C3)" where C2 is "from" and C3 is "to). However, I am looking to add waypoints to the equation, so that I can make sure it follows the actual route I want it to (i.e. using the ferry/or bridge when it's the shortest route).

I imagined it would look something like "=G_DISTANCE(C2;C3;C4)" where C3 now acts as a waypoint.

I've been trying and trying, but seeing as I am still somewhat of a novice, I haven't been able to crack it yet.

Thanks in advance.

Thanks for the quick answers.

I tried the G_DISTANCE_TOTAL, but didn't get it up and running.

Instead I chose to go with the =G_DISTANCE(Origin, WayPoint), and it has pretty much solved the problem for now.

Again - thanks.