View Single Post

  #8 (permalink)  
Old 05-01-2008
Wilfried Wilfried is offline
Senior Member
Black Belt
 
Join Date: Nov 2004
Posts: 2,017
Re: Automate Multiple Maps

Hi,

Ok now I see what you mean. 1 thing we should be very clear. The Distance value is a floating point value representing the distance in miles or kilometers. It is not a time value.

However a time value is also just a floating point value. Thus for some weird reason it is displayed as a time value in your Excel.

Your code looks ok but I don't know anything of Excel. If someone can jump in here? There must be a way to tell Excel it is not a time value but just a floating point number to display.
Reply With Quote