# Latitude Longitude Calculator

• Version
• 19 KB File Size
• January 4, 2022 Updated
• Rating
table of content

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.

Click on a star to rate it!

Average rating 5 / 5. Vote count: 10

No votes so far! Be the first to rate this template.

We are sorry 🙁

Help us improve!

How we can improve this template?

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.

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.

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

Thanks

dear sir,
I need to figure out the lattitude & longitude for
me,iwas born in delhi india.plz help