-
Member
Reputation: 49
Need help in exporting log file of scanner with lat long
i have logfile with scanner rssi value.i need to export that in excel with lat long and rssi to compare with model.But when i export those log file ,i get result lat44.1 and long 69.44 just two decimal which points same area in map.if i export in text i get reult as lat N4406.2360 and long W 06926.2218.
So can some bodyhelp me how can i get degreee decimal values of above.
-
2010-06-09 10:38 PM
# ADS
Circuit advertisement
-
Member
Reputation: 50
In Excel you can do this to convert: N4406.2360 to 44.06236, where A1 is the cell:
=(RIGHT(A1,9))/100
If Longitude is: W06926.2218
Then you should use this: =((RIGHT(A1,9))/100)*-1
To get -69.262218
Bookmarks