Convert decimal degree (lattitude/longitude) into Degree,

[Guest]

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

 

[JE McGimpsey]

Look at

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

 

[Guest]

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]

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"

 

[Guest]

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]

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\"