Latitude/Longitude conversions in Excel - Please Help

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)


<[email protected]> wrote in message
news:[email protected]...
> 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


<[email protected]> wrote in message
news:[email protected]...
>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

<[email protected]> wrote in message
news:[email protected]...
> 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
>