converting degrees minutes seconds to decimal degrees

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dano - 25 Jun 2006 20:22 GMT

Attempting to convert lat/long from degrees minutes seconds (dms) to
decimal degrees (dd). That is, I have data in dms and enter that into
columns of latitude and longitude. I want each cell to convert the dms
to dd.

I'm not able to find the formula or method in Excel Help (Excel 2004
11.2.4) or in a Google Groups search of this ng. There must be a way to
do this simple operation though...?

Signature

"What we need now are killfiles that really kill." - alt.fan.jwz

Reply to this Message

Mike Middleton - 26 Jun 2006 00:19 GMT

dano -

A general Google search of "excel latitude longitude" (without the quotes)
yields

http://www.cpearson.com/excel/latlong.htm

- Mike
www.mikemiddleton.com

> Attempting to convert lat/long from degrees minutes seconds (dms) to
> decimal degrees (dd). That is, I have data in dms and enter that into
[quoted text clipped - 4 lines]
> 11.2.4) or in a Google Groups search of this ng. There must be a way to
> do this simple operation though...?

Reply to this Message

Dan O'Donnell - 29 Jun 2006 20:00 GMT

> > Attempting to convert lat/long from degrees minutes seconds (dms) to
> > decimal degrees (dd). That is, I have data in dms and enter that into
[quoted text clipped - 10 lines]
>
> http://www.cpearson.com/excel/latlong.htm

That's perfect.
Thanks Mike.

Reply to this Message

Mac Forum / Applications / Excel / June 2006

converting degrees minutes seconds to decimal degrees