1. With a GPS, you could have a problem if you want to insert a personnal location. A GPS accept only the decimal format.
Formule de la cellule
45°21'23'' = 45.35638889
2. For instance, you want to visit the following place in France. You want to insert these location on your GPS with the POIEdit tool. But before that, you must convert the format Degree, Minute, Seconde in decimal
3. The trick is to write the position as a time by using the operator ":" Don't worry if the value is wrong yet, we'll correct it soon.
Formule de la cellule
48:51:29.99
4. Remark: If you have to fill a negative date, you must write your date in quote with the minus symbol before.
Formule de la cellule
=-"time"
5. In the case where the negative time doesn't display, and you have '#####', you must go in the menu Tools/Options. There, go in the 'Calculation' Tab and select "1904 date system"
6. Now, we create our personnal format to display our location in DMS with the Format Cells Menu (Format/Cells) It is compulsory to write the 'h' between bracket in order to display the figure beyond 23 After that, our data in the column B are a number with the DMS format.
Formule de la cellule
[hh]°mm'ss\''
7. So now, we have in the column B our data with DMS format and we have to convert them in decimal format. To do so, you just have to write the following formula in D3
Formule de la cellule
=B3*24
8. And to finish, you just have to change the format of the cell D3 with a standard format. Copy and Paste this formula with the format for the other cells, and that's all :-D
9. Try to do this exercise to make the opposite conversion.
