Conversion of Degrees Minutes Seconds to Decimal Degree in Excel for GIS- DMS to DD Formula in Excel

#Degrees
#to
#DecimalDegree
Degrees, minutes,seconds..to..Decimal,Degrees#
How to Convert degree, minutes, seconds to decimal degrees
One degree is equal to 60 minutes and equal to 3600 seconds:
1° = 60' = 3600"
One minute is equal to 1/60 degrees:
1' = (1/60)° = 0.01666667°
One second is equal to 1/3600 degrees:
1" = (1/3600)° = 2.77778e-4° = 0.000277778°
For angle with d integer degrees m minutes and s seconds:
d° m' s"
The decimal degrees dd is equal to:
dd = d + m/60 + s/3600
#Example#
Convert 30 degrees 15 minutes and 50 seconds angle to decimal degrees:
30° 15' 50"
The decimal degrees dd is equal to:
dd = d + m/60 + s/3600 = 30° + 15'/60 + 50"/3600 = 30.263888889°

For more ArcGIS @BestSolutionLine Tutorial please click the following links:

[ilyaskhan]

Decimal ko degree me kaise kary. Sob degree ko decimal me convert kar rahy per decimal ko degree me koi nahi kar raha excel me