Calculate distance between two addresses using Google Maps in Excel. Use a Microsoft Excel template to calculate driving travel time and distance for an array of locations. The triangles will help you remember these three rules.
An easy way to remember the formulae is to put distance speed and time or the letters D S and T into a triangle.
For example you can calculate travel time between all your warehouses and customer locations easily. Distance Speed. End time - Start time 24. In the Format Cells dialog box click Custom in the Category list and then select a custom format in the Type box.