Degrees, minutes, and seconds (DMS) are often used to indicate the Angular Measurements. In this article, we will learn how to convert the degrees of decimal minutes to decimal degrees in Excel.

**Table of Contents**Expand

**Degrees Decimal Minutes and Decimal Degrees**

Degree Decimal Minutes (DDM) is represented by the symbols â€˜Â°â€™, and â€˜â€™â€™ which respectively are for degrees and minutes. For example, 20Â° 16 â€˜ denotes an angle of 20 degrees and 16 minutes.

Decimal degrees (DD) is a notation for expressing geographic coordinates as decimal fractions of a degree in latitude and longitude. The decimal degrees are calculated as follows:

Decimal degrees = Degrees + (Minutes/60)

Or,

dd = d + m/60

Angles with d integer degrees, m minutes are as dÂ° mâ€™.

**Calculation for Converting Degrees Decimal Minutes to Decimal Degrees**

60 minutes is equal to one degree:

1Â° = 60â€²

1/60 degrees equals one minute:

1â€² = (1/60)Â°

And, we already know that Angles with d integer degrees, m minutes are dÂ° mâ€™. Also, dd stands for decimal degrees and is equal to, dd = d + m/60.

For example, letâ€™s see the calculation to convert 20 degrees and 16 minutes to decimal degrees.

20Â° 16â€²

= 20Â° + 16â€™/60

= 20.27Â°

**Convert Degrees Decimal Minutes to Decimal Degrees in Excel: 2 Methods**

To convert degrees decimal minutes to decimal degrees we are going to use the following dataset which contains some degrees decimal minutes (DDM) in column **B**. We will see the conversion in a different column named Decimal Degrees (DD). We can convert the angular dimension in two different ways in Excel. Letâ€™s go through the methods to convert the angular measurements.

**1. Apply Simple Formula to Convert Degrees Decimal Minutes to Decimal Degrees in Excel**

Excel has no built-in function or formula to convert the angular measurements. Even then we can convert the angular dimensions in Excel. We can use the formula shown in the above sections of the article. But to use that formula, we must remove the degree and minutes symbols first. Thatâ€™s the reason we put another column named Minutes in our dataset. So, letâ€™s see the procedure down to convert the degrees decimal minutes to decimal degrees.

**STEPS:**

- Firstly, select any of the degrees decimal minutes cells. So we select
**B5**. And by selecting the cell you are able to see the value in the formula bar. - Secondly, copy the degree symbol â€˜
**Â°**â€™.

- After that, select the range
**B5:B10**.

- Next, go to the
**Data**tab from the ribbon. - Then, click on the
**Text to Columns**command under the**Data Tools**group.

- This will appear in the
**Convert Text to Columns Wizard**. - After that, choose the file type
**Delimited**. - Then, click on
**Next**. And you are done with**Convert Text to Columns Wizard Step 1**.

- Further, checkmark the box
**Other**under**Delimiters**.

- Now, paste the copied degree symbol â€˜
**Â°**â€™ to the box beside**Other**. - And, click on
**Next**. And, you are finished with**Convert Text to Columns Wizard Step 2**.

- Furthermore, select
**General**in the**Column data format**selection menu. - And, finally, click on the
**Finish**button.

- This will appear in a Microsoft dialog box for your confirmation.
- Click on the
**OK**button.

- And, you can see the degrees and minutes are separated now and the symbol of the degrees is removed.

- Secondly, by the same token, we need to remove the minuteâ€™s symbol â€˜
**â€˜**â€™. - In that, choose any of the minute cells. As a result, we choose cell
**B5**. You may also see the value in the formula bar by selecting the cell. - Copy the â€˜
**â€˜**â€™ sign for minutes.

- After that, choose the
**C5:C10**range. - Then, from the ribbon, select the
**Data**tab. - After selecting the tab, in the
**Data**Tools group, select the**Text to Columns**command.

- The
**Convert Text to Columns Wizard**will display. - Select
**Delimited**as the file type. - Next, click on the
**Next**button. And thatâ€™s it for the**Convert Text to Columns Wizard**â€™s first step.

- Also, under
**Delimiters**, tick the box**Other**. - Place the copied minutes symbol â€˜
**â€˜**â€™ in the box next to**Other**. - Now, click
**Next**.

- Additionally, in the
**Column data format**options menu, pick**General**. - Last but not least, hit the
**Finish**button.

- And, as you can see, the degrees and minutes have been split, and the minuteâ€™s symbol has been eliminated.

**PRINCIPAL STEPS:**

- First, select the cell, where you want to see the conversion. So, we select cell
**E5**. - After that, type the formula there.

`=B5+C5/60`

`Â `

- Now, if you click on the resulting cell, the formula will show in the formula bar.

Here, **B5 **is the degree and **C5 **is the minutes. We are using the formula **Decimal degrees = Degrees + (Minutes/60)**.

- After that, drag the
**Fill Handle**over the range**E6:E10**.**Â**

- And finally, the degrees decimal minutes are converted to decimal degrees.

**2. Excel User-Defined Function to Transpose Degrees Decimal Minutes to Decimal Degrees**

We are now creating a user-defined function using the** Excel VBA** to convert the degrees decimal minutes to decimal degrees. Letâ€™s demonstrate the steps below about how we can create the function and use the function in our spreadsheet.

**STEPS:**

- In the beginning, go to the
**Developer**tab from the ribbon. - After that, click on
**Visual Basic**to open the**Visual Basic Editor**. - Another way to open the
**Visual Basic Editor**is simply to press**Alt + F11**.

- Or, right-click on the sheet, then select
**View Code**.

- Next, go to
**Insert**and select**Module**from the drop-down menu.

- After that, copy and paste the VBA code below.

**VBA Code:**

```
Function Decimal_Degrees(Degree_d As String) As Double
Dim degrees As Double
Dim minutes As Double
Degree_d = Replace(Degree_d, "~", "Â°")
degrees = CDbl(Left(Degree_d, InStr(1, Degree_d, "Â°") - 1))
minutes = CDbl(Mid(Degree_d, InStr(1, Degree_d, "Â°") + 1, _
InStr(1, Degree_d, "'") - InStr(1, Degree_d, "Â°") - 1)) / 60
Decimal_Degrees = degrees + minutes
End Function
```

- Then, save the code by pressing
**Ctrl + S**.

- This will create a function named
**Decimal_Degrees**. - Now, go back to the workbook and select the cell where we want the converted result to appear. So, we select cell
**E5**. - And you can see a function is added to our spreadsheet.

- Type the formula we have just created.

**=Decimal_Degrees(B5)**

- Press
**Enter.** - And, if you click on the resulting cell, the formula will appear in the formula bar.

- Next, drag the
**Fill Handle**down to copy the formula.

- And, thatâ€™s it. We can now see the converted result.

**Download Practice Workbook**

You can download the workbook and practice with them.

**Conclusion**

By using the above methods you will be able to convert the degrees decimal minutes to decimal degrees in Excel. Hope this will help you! If you have any questions, suggestions, or feedback please let us know in the comment section.

**<< Go Back to Geocoding in Excel | Learn Excel**