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

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

--

HTH

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


wrote in message
ps.com...
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

Knickel,

Would using time formats be any use to you?

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

Henry


wrote in message
ps.com...
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

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

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

wrote in message
oups.com...
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