Google Distance Matrix API - Distance and Time

Hi All,

I have found a excel function on the net the works quite well for what I need. Only problem is I cant seem to split the 'Time' and 'Distance' into 2 separate cells. It returns the distance+time in the same cell.

I have got it to only return the distance or time also but still cannot split the two values into separate cells.

Any assistance would be appreciated.

Download Working File: Download Working File https://www.box.com/s/3ai8xgasra8kpsgt40lq

Please Login or Register  to view this content.