Results 1 to 5 of 5

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

  1. #1
    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. #2
    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. #3
    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. #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. #5
    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.

Similar Threads

  1. How to get degree symbol (Celsius) in each cell of Excel
    By New!life in forum MS Office Support
    Replies: 2
    Last Post: 25-02-2012, 09:53 AM
  2. Bachlor degree is must for job abroad
    By SagarP in forum Education Career and Job Discussions
    Replies: 4
    Last Post: 30-03-2011, 03:32 PM
  3. Can i get a job on the base of BCA degree
    By Soumen in forum Education Career and Job Discussions
    Replies: 3
    Last Post: 23-02-2011, 04:07 PM
  4. Replies: 3
    Last Post: 26-11-2010, 11:59 PM
  5. Master Degree
    By nileshtathare in forum Education Career and Job Discussions
    Replies: 3
    Last Post: 10-11-2008, 06:41 PM

Posting Permissions

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