Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Tim Ashcom
 
Posts: n/a
Default 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   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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   Report Post  
Tim Ashcom
 
Posts: n/a
Default

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   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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   Report Post  
Tim Ashcom
 
Posts: n/a
Default

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   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert decimal hour into time format? ramdalen Excel Discussion (Misc queries) 2 June 20th 05 06:21 PM
Convert degree from decimal number to the standard format (degre. Zainelabdin Excel Discussion (Misc queries) 3 March 27th 05 12:37 PM
convert decimal number to time : convert 1,59 (minutes, dec) to m agenda9533 Excel Discussion (Misc queries) 8 January 20th 05 11:24 PM
how to convert total hours (HH:MM) into decimal number Greg T Excel Worksheet Functions 1 November 17th 04 04:07 PM
How to convert decimal values (dd.dddddd) to degrees/minutes/seco. Florin Balcu Excel Worksheet Functions 2 November 12th 04 06:12 AM


All times are GMT +1. The time now is 06:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"