Coordinates with Excel convert
The coordinates can be converted into each other – however, Excel is expecting decimal data and provides no special format for the Geo-coordinates the usual angle units of arc-seconds and minutes. Here is a Trick can help: Since the degree corresponds to the sub-division of a division of time, the desired representation through the Use of time formats to achieve:
- Table set up: For the entry of the division on three cells is recommended. Enter in cell "A3" of the Degrees, in "B3" in the minutes of arc and in "C3" the seconds of arc. The unwanted cell fill with "0".
- Formats transform: To Calculate the decimal degrees you "=A3+B3/60+C3/3600" in cell "E3 type". This is the Format you need, for example, for information in Flickr. The result of use in the further course, also to Determine other coordinate representations. The Excel's built-in time formats are used: These can be used creatively and to adjust the display of hours, minutes and seconds for use with angle values. Because Excel values all the time as the fractional saves parts of a day, the first step is a Division by 24 and thereafter, the Processing of the hour. Enter to cell F3 the formula "=E3/24".
- In the next step, you will open to convert the result in cell F3 (which must be marked) "Format" > "cells" and change to Pay the tab. Select the category "user defined" and right click in the "type" field. Type in the Code "[h]° mm' ss. 000\";@" as the number format and confirm with "OK". The in the square brackets is "h" causes a continuous indication of hours, which is here extended with the degree sign.
Gedodaten with Excel convert
Transform coordinates in GPS
A little tricky you need to approach for the GPS is usual in the wagon format. Here the decimal places following decimal point, namely, directly behind the arc minutes, which requires a formatting process after time seconds. The degree information will then be represented by the time minutes and need to be converted:
- Enter in cell G3, the formula "=E3/1440" open cell "G3" re - "Format" > "cells". In the tab "Numbers", select the category "user defined".
- In the "type" field,enter the Code "[mm]° ss, 000';@".
- After a mouse click on "OK", Excel calculates the GPS Format, and represents it correctly.
For more Tricks and how-to Excel can be found on our Excel-topic pages.
