Using Excel 2003
I have a list of GPS data, Latitude in column I and Longitude in column J starting in row 3, if I put a Latitude and Longitude location in R1 and S1 is there anyway to get the miles between them to show up in column M? The date is in decimal format and example would be if I put 34.084317 in R1 and -83.729373 in S1 than with 34.68371778 in I3 and -83.70893544 in J3 M3 would show 55.6 miles, and fill in the miles in M for the rest of the data I have in columns I and J. If that can be done could the travel time also be put in another cell?
I have a list of GPS data, Latitude in column I and Longitude in column J starting in row 3, if I put a Latitude and Longitude location in R1 and S1 is there anyway to get the miles between them to show up in column M? The date is in decimal format and example would be if I put 34.084317 in R1 and -83.729373 in S1 than with 34.68371778 in I3 and -83.70893544 in J3 M3 would show 55.6 miles, and fill in the miles in M for the rest of the data I have in columns I and J. If that can be done could the travel time also be put in another cell?