What is the formula to convert Degrees, Minutes, Seconds (33°42'22.37"N) to
Decimal Degrees (33.706214°)?

See Chip's site. http://www.cpearson.com/excel/LatLong.aspx


John



"HELPexcel" <(E-Mail Removed)> wrote in message news:00A7551D-A6E0-4D62-B05A-(E-Mail Removed)...
> What is the formula to convert Degrees, Minutes, Seconds (33°42'22.37"N) to
> Decimal Degrees (33.706214°)?
>
>

On Jul 30, 5:17*pm, "jaf" <m...@here.com> wrote:
> See Chip's site.http://www.cpearson.com/excel/LatLong.aspx
>
> John
>
> "HELPexcel" <HELPex...@discussions.microsoft.com> wrote in messagenews:00A7551D-A6E0-4D62-B05A-(E-Mail Removed)...
> > What is the formula to convert Degrees, Minutes, Seconds (33°42'22.37"N) to
> > Decimal Degrees (33.706214°)?

Thank you.

On Jul 30, 6:01*pm, jamescox <jamescox.3w5...@thecodecage.com> wrote:
> One way to read your question is how to do it mathematically - the quick
> answer for that is
>
> degrees + (minutes / 60) + (seconds / 3600)
>
> In terms of how to work with DMS in Excel, another thread that includes
> link John mentioned is at
>
> 'Format to Degrees, Minutes, Seconds - MrExcel Message Board'
> (http://www.mrexcel.com/forum/showthread.php?t=68869)
>
> It probably makes a difference if you are dealing with longitude and
> latitude or if you are working in the engineering realm where degrees
> can be from 0 to 359...
>
> --
> jamescox
> ------------------------------------------------------------------------
> jamescox's Profile:http://www.thecodecage.com/forumz/member.php?userid=449
> View this thread:http://www.thecodecage.com/forumz/sh...d.php?t=121150

Thank you too!