Latitude Longitude Calculator
- Version
- 6'411 Downloads
- 19 KB File Size
- January 4, 2022 Updated
- 11 Number of comments
- Rating
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.
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.
Hi I have several hundred lats and longs that I wish to convert to eastings northings do you have a macro/formulae I can use in excel? lats longs are degree minutes seconds and eastings/northings are for the UK.
Many thanks.
Kev
All,
To convert Lat and Long to Northing and Easting (or also called Geodetic to Grid) you need to know UTM zone as Northing and Easting is uniq for each UTM zone.
Will recommend to google web sites which will help you to do so.
Cheers,
Omar
All,
To convert Lat and Long to Northing and Easting (or also called Geodetic to Grid) you need to know UTM zone as Northing and Easting is uniq for each UTM zone.
Will recommend to google web sites which will help you to do so.
Cheers,
Omar
sir
i have lattitude and longitude. I wants to convert to easting and norhting, but how. Please send formula in my mail id.
E.g. 32d 17’47” lattitue
75d52’56”
Dear Sir,
I collected several eastings and northings and need to convert them into decimal degrees. My eastings and northings were collected in WGS84 UTM Zone 57N. I wanted to convert these eastings and northings using Excel, what are the formulas should I use in converting my eastings and northings? Appreciate your assistance.
An example of my easting and northing:
easting: 419395
northing: 765172
Thank you.
tengo cordenadas en utm quiciera convertirlas a grados decimales sera q eya una plantilla en excel para no entrar a internet
My son was born on oct. 23, 1998 at 1:20pm in grenta, louisiana how can i get the longitude and laditude of his birth ..im looking into getting a tattoo of this.
Dear Sir
I need to conert the following Northing Easting into longitute and latitude.
N = 1041238.10
E = 2277650.700
Reply me hurry.
Thanks
dear sir,
I need to figure out the lattitude & longitude for
me,iwas born in delhi india.plz help
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
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?