How to convert GPS data into degrees, minutes and seconds

1. After starting Excel, enter the following data in columns A and B, and columns C and D are the converted output results.

2. The text function is mainly used to convert the specific content into the required format. Enter the latitude and longitude test data in B3 cell: 50.4564.000000000005 and enter the formula = text in column C (B3/24, "[h] m' SSS.000" ") to complete the conversion between numerical value and minute and second.

3.Text This function converts numeric values into text and allows you to use special format strings to specify the display format.

4. Enter the second data in latitude and longitude to the fourth second after minutes. Input formula: = text (int (B3), "0")&; ”& ampTEXT(INT((B3-INT(B3))*60)，" 00))& amp； “’”& amp； TEXT((B3-INT(B3))* 60-INT((B3-INT(B3))* 60))* 60，" 00.0000 ")& amp； """will.

5. Use substitution function to get the values of degree, minute and second respectively, and then calculate and complete the conversion. Enter the formula in column C: = substitute (substitute (a3, "",":),"' ",":), "",) * 24 to complete the conversion between numerical values and minutes.