| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DMS to DD
What is the formula to convert Degrees, Minutes, Seconds (33°42'22.37"N) to
Decimal Degrees (33.706214°)? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DMS to DD
See Chip's site. http://www.cpearson.com/excel/LatLong.aspx
John "HELPexcel" wrote in message ... What is the formula to convert Degrees, Minutes, Seconds (33°42'22.37"N) to Decimal Degrees (33.706214°)? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DMS to DD
One way to read your question is how to do it mathematically - the quick answer for that is degrees + (minutes / 60) + (seconds / 3600) In terms of how to work with DMS in Excel, another thread that includes link John mentioned is at 'Format to Degrees, Minutes, Seconds - MrExcel Message Board' (http://www.mrexcel.com/forum/showthread.php?t=68869) It probably makes a difference if you are dealing with longitude and latitude or if you are working in the engineering realm where degrees can be from 0 to 359... -- jamescox ------------------------------------------------------------------------ jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121150 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DMS to DD
On Jul 30, 5:17*pm, "jaf" wrote:
See Chip's site.http://www.cpearson.com/excel/LatLong.aspx John "HELPexcel" wrote in ... What is the formula to convert Degrees, Minutes, Seconds (33°42'22.37"N) to Decimal Degrees (33.706214°)? Thank you. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DMS to DD
On Jul 30, 6:01*pm, jamescox wrote:
One way to read your question is how to do it mathematically - the quick answer for that is degrees + (minutes / 60) + (seconds / 3600) In terms of how to work with DMS in Excel, another thread that includes link John mentioned is at 'Format to Degrees, Minutes, Seconds - MrExcel Message Board' (http://www.mrexcel.com/forum/showthread.php?t=68869) It probably makes a difference if you are dealing with longitude and latitude or if you are working in the engineering realm where degrees can be from 0 to 359... -- jamescox ------------------------------------------------------------------------ jamescox's Profile:http://www.thecodecage.com/forumz/member.php?userid=449 View this thread:http://www.thecodecage.com/forumz/sh...d.php?t=121150 Thank you too! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
