Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



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

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 25-01-2012
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.

Reply With Quote
  #2  
Old 25-01-2012
Member
 
Join Date: Jun 2011
Posts: 486
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".
Reply With Quote
  #3  
Old 25-01-2012
Member
 
Join Date: Jun 2011
Posts: 798
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").
Reply With Quote
  #4  
Old 25-01-2012
Member
 
Join Date: May 2011
Posts: 446
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\".
Reply With Quote
  #5  
Old 25-01-2012
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.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "What are the possible ways to convert a decimal degree to degree in Excel"
Thread Thread Starter Forum Replies Last Post
How to get degree symbol (Celsius) in each cell of Excel New!life MS Office Support 2 25-02-2012 09:53 AM
Bachlor degree is must for job abroad SagarP Education Career and Job Discussions 4 30-03-2011 03:32 PM
Can i get a job on the base of BCA degree Soumen Education Career and Job Discussions 3 23-02-2011 04:07 PM
How to convert a decimal number into words in Excel using VBA? Gandhik Windows Software 3 26-11-2010 11:59 PM
Master Degree nileshtathare Education Career and Job Discussions 3 10-11-2008 06:41 PM


All times are GMT +5.5. The time now is 06:45 AM.