# Thread: What are the possible ways to convert a decimal degree to degree in Excel

1. Member
Join Date
Oct 2011
Posts
89

## 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.

2. Member
Join Date
Jun 2011
Posts
492

## 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".

3. Member
Join Date
Jun 2011
Posts
804

## 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").

4. Join Date
May 2011
Posts
449

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

5. Member
Join Date
May 2011
Posts
410

## 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.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•