Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Look at
http://cpearson.com/excel/latlong.htm In article , "Tim Ashcom" 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 |
#3
|
|||
|
|||
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 , "Tim Ashcom" 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 |
#4
|
|||
|
|||
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 , "Tim Ashcom" 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. |
#5
|
|||
|
|||
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 , "Tim Ashcom" 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. |
#6
|
|||
|
|||
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 , "Tim Ashcom" 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"). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert decimal hour into time format? | Excel Discussion (Misc queries) | |||
Convert degree from decimal number to the standard format (degre. | Excel Discussion (Misc queries) | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
how to convert total hours (HH:MM) into decimal number | Excel Worksheet Functions | |||
How to convert decimal values (dd.dddddd) to degrees/minutes/seco. | Excel Worksheet Functions |