Convert decimal degree (lattitude/longitude) into Degree,

Need formulae to convert decimal degree (lattitude/longitude) into Degree,
Minutes, Seconds format.

I have the following:
Lattitude data of 0.1741463938 and to convert to decimal degrees, I muliply
by 180 which gives me decimal degrees of 31.3463508840. Now I need to
convert to a Degree, Minute, Seconds format (N34* 50' 56.04"). Note: the '*'
represents the 'degree' symbol - did not know how to display the symbol.
Need to also display whether 'N' (North) or 'S' (South) based on actual
coordinate.

For Longitude, I have data of -0.4758427618 *180 = -85.6516971240 (decimal
degrees) and need to also convert to Degree, Minute, Seconds format (W16* 40'
23.54"). Note: the '*' represents the 'degree' symbol - did not know how to
display the symbol. Need to also display whether 'W' (West) or 'E' (East)
based on actual coordinate.

The formulae needed will take the original lat/long data, multiplied by 180,
and then ???? applied to deliver the data in Degrees, Minutes, Seconds format.

Thank you very much for your assistance.

Tim

Look at

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


In article <[email protected]>,
"Tim Ashcom" <[email protected]> wrote:

> Need formulae to convert decimal degree (lattitude/longitude) into Degree,
> Minutes, Seconds format.
>
> I have the following:
> Lattitude data of 0.1741463938 and to convert to decimal degrees, I muliply
> by 180 which gives me decimal degrees of 31.3463508840. Now I need to
> convert to a Degree, Minute, Seconds format (N34* 50' 56.04"). Note: the '*'
> represents the 'degree' symbol - did not know how to display the symbol.
> Need to also display whether 'N' (North) or 'S' (South) based on actual
> coordinate.
>
> For Longitude, I have data of -0.4758427618 *180 = -85.6516971240 (decimal
> degrees) and need to also convert to Degree, Minute, Seconds format (W16* 40'
> 23.54"). Note: the '*' represents the 'degree' symbol - did not know how to
> display the symbol. Need to also display whether 'W' (West) or 'E' (East)
> based on actual coordinate.
>
> The formulae needed will take the original lat/long data, multiplied by 180,
> and then ???? applied to deliver the data in Degrees, Minutes, Seconds format.
>
> Thank you very much for your assistance.
>
> Tim

I did, but not much help for a novice Excel user. What will help the best is
an exact formula to do the calculations.

Thanks for any additional assistance.

Tim

"JE McGimpsey" wrote:

> Look at
>
> http://cpearson.com/excel/latlong.htm
>
>
> In article <[email protected]>,
> "Tim Ashcom" <[email protected]> wrote:
>
> > Need formulae to convert decimal degree (lattitude/longitude) into Degree,
> > Minutes, Seconds format.
> >
> > I have the following:
> > Lattitude data of 0.1741463938 and to convert to decimal degrees, I muliply
> > by 180 which gives me decimal degrees of 31.3463508840. Now I need to
> > convert to a Degree, Minute, Seconds format (N34* 50' 56.04"). Note: the '*'
> > represents the 'degree' symbol - did not know how to display the symbol.
> > Need to also display whether 'N' (North) or 'S' (South) based on actual
> > coordinate.
> >
> > For Longitude, I have data of -0.4758427618 *180 = -85.6516971240 (decimal
> > degrees) and need to also convert to Degree, Minute, Seconds format (W16* 40'
> > 23.54"). Note: the '*' represents the 'degree' symbol - did not know how to
> > display the symbol. Need to also display whether 'W' (West) or 'E' (East)
> > based on actual coordinate.
> >
> > The formulae needed will take the original lat/long data, multiplied by 180,
> > and then ???? applied to deliver the data in Degrees, Minutes, Seconds format.
> >
> > Thank you very much for your assistance.
> >
> > Tim
>

I don't understand your calculations

How are you going from decimal degrees of 31.3463508840 to N34* 50'
56.04"?? Where are the extra degrees coming from?

Seems to me that 31.3+ decimal degrees should yield a DMS of

31°20'46.86"




In article <[email protected]>,
"Tim Ashcom" <[email protected]> wrote:

> I did, but not much help for a novice Excel user. What will help the best is
> an exact formula to do the calculations.
>
> Thanks for any additional assistance.

JE,

The original data comes from a Flight Data Recorder parameter. We have to
multiply the data by 180 to convert to a decimal degree format. Now what I
need is to know how to convert from decimal degree (dd) to degrees, minutes,
and seconds (dd mm' ss").

Thanks,

Tim

"JE McGimpsey" wrote:

> I don't understand your calculations
>
> How are you going from decimal degrees of 31.3463508840 to N34* 50'
> 56.04"?? Where are the extra degrees coming from?
>
> Seems to me that 31.3+ decimal degrees should yield a DMS of
>
> 31°20'46.86"
>
>
>
>
> In article <[email protected]>,
> "Tim Ashcom" <[email protected]> wrote:
>
> > I did, but not much help for a novice Excel user. What will help the best is
> > an exact formula to do the calculations.
> >
> > Thanks for any additional assistance.
>

That's fine, but there's no way 31.3463508840 decimal degrees converts
to N34°50' 56.04" without adding or multiplying by another factor.

31 decimal degrees will convert to 31 degrees in DMS format, too.

Again, to convert to 31°20' 46.86", just follow Chip's instructions:
Divide by 24 and format using the custom format [hh]°mm'ss\"



In article <[email protected]>,
"Tim Ashcom" <[email protected]> wrote:

> The original data comes from a Flight Data Recorder parameter. We have to
> multiply the data by 180 to convert to a decimal degree format. Now what I
> need is to know how to convert from decimal degree (dd) to degrees, minutes,
> and seconds (dd mm' ss").