What are the possible ways to convert a decimal degree to degree in Excel
Need formula to convert decimal degree (latitude/longitude) into Degree, Minutes, Seconds format. I have the following. Attitude data of 0.1741463938 and to convert to decimal degrees, I multiply 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 formula 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.
Re: What are the possible ways to convert a decimal degree to degree in Excel
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".
Re: What are the possible ways to convert a decimal degree to degree in Excel
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").
Re: What are the possible ways to convert a decimal degree to degree in Excel
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\".
Re: What are the possible ways to convert a decimal degree to degree in Excel
I can give you a sample of the same via gps entries. I have done this and want to add the tags. First, you must write your GPS readings in hours, minutes, seconds as if it were one hour, using the symbol of separation ":". To enter negative hours in Excel, write time quotes preceded by the sign "-", as attached. In this case, time does not display negative and shows ###### instead. To correct the problem, simply open the options of Excel, to go to the Calculation tab and check the '1904'. In Excel 2010 and 2007, you find that option in File / Option and you check the following In Excel 2003 and earlier, you will find this option in Tools / Option and you check the next option.
Next, you create a custom format to display the symbols DMS using the Format dialog box / cell. It is imperative to put the symbol of the time in brackets to display values greater than 23. After validation, column B contains our positions at DMS.