VBA Route Calculator - Google Maps Api 22 Minutes quicker than Actual Google Website

Hi,

I shamelessly downloaded an Excel route distance and time calculator online and I've tweaked the VBA code to help cater my end goals.

I've added some extra via's that I needed (as the original only contained two), chosen to avoid tolls and I've changed the units to metric as I need it in kilometers, as opposed to miles.

All seemed well.

However, I ran an example through the Excel version and compared to the same route.

The distance is exact, but the time is always 22 minutes quicker on the Excel result than if I run the same scenario through the Google maps online website.

I've checked through the code but I'm unable to find out how to add those 23 minutes on to the final time so was wondering if any one could please give me some pointer on where abouts to do this?

I imagine it's something to do with this part, perhaps...

Please Login or Register  to view this content.

The full code is as follows:

Please Login or Register  to view this content.

Step through the code (F8) and using the Locals window or the Watches window (highlight a variable then hit Shift + F9), watch the values of all your time-related variables. Do those variables ever sync with the Google results? If so, at what point do they no longer sync? If not, at what line are they getting assigned incorrect values?

Id agree, theres no use trying to hack the results to match, you need to find the problem. What happens if you put a route in that is less than 22minutes long?