Excel Templates | Excel Spreadsheets | Latitude Longitude Calculator



Latitude Longitude Calculator

Posted on August 7, 2009
Filed Under Other |



If you need a calculator to calculate the conversion of Latitude and Longitude from decimals to degrees, minutes, seconds and vice versa, you can use this simple tool created in excel. In the beginning, I tried to find the ready made function in excel, but I couldn’t find it. So, I created the function using the LEFT, RIGHT and FIND function to separate the coordinates to ease the conversion process.

Latitude Longitude

To use this calculator is simple, just fill the coordinate you want to convert in input box and see the result in output box. The formula being used to convert is as follow :

Conversion from degrees, minutes, and seconds to decimal
Coordinate example : Latitude 21o33′24″ S or 21 degrees, 33 minutes and 24 seconds with South direction
The formula : Decimal degrees = degrees + minutes/60 + seconds/3600
Applied formula : 21 + 33/60 + 24/3600
Result : 21.55667
Direction rule : South and West are negative, North and East are positive
Final result : -21.55667

Conversion from decimal to degrees, minutes, and seconds
Coordinate example : Latitude -21.55667
The formula :
Degree = D.ddddd (decimal degree) - 0.ddddd
Minutes =  M.mmmmm (0.ddddd x 60) - 0.mmmmm
Seconds = 0.mmmmm x 60
Applied formula :
Degree = 21.55667 - 0.55667 = 21
Minutes = 0.55667 x 60 = 33.40020 - 0.40020 = 33
Seconds = 0.40020 x 60 = 24.01200
Result : 21o33′24.012″ and you can round up the seconds into two digits only
Direction rule : South and West are negative, North and East are positive
Final result : 21o33′24″ S

You can learn about applying the excel function to interpret those formulas above in the worksheet. And you can download the file here.


You can read and download my other templates below :

Tags: , , , , , , , , ,

Comments

3 Responses to “Latitude Longitude Calculator”

  1. SHOJI on September 14th, 2009 5:55 am

    Thanks a lot for this informative work…really good…

  2. sushma on October 5th, 2009 4:39 am

    I need to figure out the lattitude & longitude for my son’s birth place. I need to get his horoscope. He was born in Burnaby, British Columbia.
    Can you help?

  3. Sadhik batcha on December 14th, 2009 2:19 pm

    Dear sir,
    I have latitute and longitude.I want to convert easting,northing.

    EX.9° 54′ 40.31522″ N
    78° 06′ 43.13941″ E
    Pls reply me through my mail

Leave a Reply