Latitude/Longitude conversions in Excel - Please Help

[knickel]

I regularly use Latitude and Longitude in all three formats, and though
I have looked through the topics here, I cannot find one that deals
with a formula to convert from one form to the other two.

For instance, I have the DD MM.DEC format, and I would like to convert
it to both DD MM SS and DD.DEC formats. Is there anyone that has dealt
with this before?

Thank you, Kit Nickel

 

[Bob Phillips]

See if Chip's page helps http://www.cpearson.com/excel/latlong.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Henry]

Knickel,

Would using time formats be any use to you?

HH:MM:SS is equivalent to DD:MM:SS

Henry

 

[knickel]

Thanks very much for the comments thus far. I have tried Chip's page,
but it converts from decimal to degrees minutes seconds (D M S) without
the middle step. I need to start with the middle step (degrees
minutes.decimal), and go to decimal and degrees minutes seconds.

For instance, starting from 39 56.811 / 83 2.919 to:

Decimal: 39.94685 / 83.04865
D M S: 39 56 48.66 / 83 2 55.14

I have a mapping program for my county of residence that will provide
the format above, and I need to convert these coordinates into the
formats used by other folks that I work with. Again, thank you for your
assistance. It is greatly appreciated.

Kit Nickel

 

[Henry]

knickel,

Put the whole degrees in A1 and the minutes portion in B1.
In C1 put the formula
=A1+B1/60
In D1 put the formula
A1&" "&INT(B1)&" "& MOD(B1,1)*60

For 39 in A1 and 56.811 in B1, this will give you
In C1
39.94685
and in D1
39 56 48.66

There may be a way of putting 39 56.811 in one cell, getting excel to look
for the space and extracting the degrees and minutes portions.
I don't know how to do that in a formula but I can do it in a macro, if
that's any use to you.
If it's possible to do it in a formula, someone else here will know how.

Henry