Friday 18 October 2013

Converting Latitude and Longitude

We have been putting our river data from our fieldtrip into Google Earth using the GE Graph program.  It is great fun, but we have hit a little glitch: getting the coordinates into a suitable format in Excel which is easy to copy and paste into the graph program was a real fiddle. The graph program wants it in a decimal format; GE gave us degrees, minutes and seconds.

I found this nice little converter and it works well. If you are feeling more adventurous you could just type the formula into your spreadsheet (follow the link on the converter page).

Good Google Earthing!