How can I calculate the driving time between many origins and three corresponding destinations?

Question

I have a spreadsheet with many origins and three destinations.  I need to calculate the driving time between each origin and its corresponding destination. The origins and destinations are in the same spreadsheet.  I geocoded the origins and destinations separately. Any advice is appreciated.  Thanks!

Ryan_ESRICommunity · Answer

Hello Lawrence et al,

Indeed, I'm asking the same question and I'm wondering if there's been any movement or workaround solutions on this thread? Perhaps someone from ESRI can weight in? Essentially what's needed is the integration of the Generate Origin-Destination Links GP tool within the OD Cost Matrix function that resides in Network Analyst to facilitate drive times instead of as-the-crow fly distances. Curious if anyone has scripted some like this?  Thanks!

RamonPablo · Answer

Hi Lawrence

Did you get any success?

I have exactly the same problem as you. How could I set the OD matrix properties in order to know the distance between many origins and their corresponding destinations?

Thanks in advance

LawrenceRoakes · Answer

Thanks Dan! I have Network Analyst and have run OD Cost Matrix. How do I get Analyst to calculate the travel time from an origin to a specific designated destination? Instead of Analyst choosing a destination based on parameters, the destinations are already designated. I do not need the route shapes, just the straight lines and the travel time. My data is shaped per the table below.

Record #OriginDestination1Address 1A2Address 2B3Address 3C4Address 4A5Address 5A6Address 6B7Address 7B

Lawrence Roakes