Distance (Km) Calculation and Travel Time between 2 Cities
Solved
Ololyxes
Posted messages
60
Registration date
Status
Membre
Last intervention
-
cairnoc Posted messages 14 Status Membre -
cairnoc Posted messages 14 Status Membre -
Hello everyone,
I know that many topics exist but I can't find the one that works. For your information, I work with Office 365.
My sales representatives travel to our clients to assemble equipment delivered on-site. Since the assembly time is low, they sometimes cross their area for 15-20 minutes of assembly without counting the travel time, the cost, the fatigue... I want to assemble the equipment at our logistics platform and deliver the assembled equipment. To do this, I want to estimate the time spent last year on the road and the kilometers traveled between their home and the different clients delivered. I already have their postal code and the postal codes of the clients. To avoid using Mappy or ViaMichelin one by one, I want to perform this calculation using Excel.
Do you have a solution that meets this need?
For example: a starting postal code and then a list of destination postal codes (the goal is to have a bulk calculation rather than one by one).
Thank you in advance, and I will of course enjoy reading your comments which have often helped me!
I know that many topics exist but I can't find the one that works. For your information, I work with Office 365.
My sales representatives travel to our clients to assemble equipment delivered on-site. Since the assembly time is low, they sometimes cross their area for 15-20 minutes of assembly without counting the travel time, the cost, the fatigue... I want to assemble the equipment at our logistics platform and deliver the assembled equipment. To do this, I want to estimate the time spent last year on the road and the kilometers traveled between their home and the different clients delivered. I already have their postal code and the postal codes of the clients. To avoid using Mappy or ViaMichelin one by one, I want to perform this calculation using Excel.
Do you have a solution that meets this need?
For example: a starting postal code and then a list of destination postal codes (the goal is to have a bulk calculation rather than one by one).
Thank you in advance, and I will of course enjoy reading your comments which have often helped me!
4 réponses
Hello,
Actually, if it hadn't messed up at your place, I could have forgotten about the thank you?
As with many issues where you only come back if dissatisfied...
Okay, noted.
eric
--
By continually trying, you eventually succeed.
So the more it fails, the more chances we have for it to work. (the Shadoks)
In addition to the thank you (yes, it does happen!!!), remember to mark as resolved. Thank you.
Actually, if it hadn't messed up at your place, I could have forgotten about the thank you?
As with many issues where you only come back if dissatisfied...
Okay, noted.
eric
--
By continually trying, you eventually succeed.
So the more it fails, the more chances we have for it to work. (the Shadoks)
In addition to the thank you (yes, it does happen!!!), remember to mark as resolved. Thank you.
I didn't mean to offend you and I will now be very careful to respond to you promptly with a great thank you. I assume you have re-read all of my 12,000 questions and have made comparisons to conclude that I am an ungrateful person who never answers and never thanks.
I will try in the future to be more worthy of your time and great thought...
But seriously... you don't bring up the fact that I highlight in every message that your help (yes yes, yours too, THANK YOU) is very valuable and insightful. So yes, I don’t go back to every message at the end, it happens...
I salute you, revered ERIC, who deserves the utmost respect from a poor peasant without education like myself....
And to perfect your education, since what should be obvious is not for some:
https://www.commentcamarche.net/infos/25855-charte-d-utilisation-de-commentcamarche-net-respect-d-autrui/#remerciements