| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert decimal degrees to circular degrees (deg,min,sec)
What formula is used to convert decimal degrees to circular degrees
(deg,min,sec) and visa versa? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert decimal degrees to circular degrees (deg,min,sec)
for a really good discussion see:
http://www.cpearson.com/excel/latlong.htm -- Gary''s Student - gsnu200719 "Benn-at-Bax" wrote: What formula is used to convert decimal degrees to circular degrees (deg,min,sec) and visa versa? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert decimal degrees to circular degrees (deg,min,sec)
When I do this, the "dd" represents DAYS not degress so the conversion result
always shows a max of "30" or "31" for degrees then goes back to 1. "Gary''s Student" wrote: for a really good discussion see: http://www.cpearson.com/excel/latlong.htm -- Gary''s Student - gsnu200719 "Benn-at-Bax" wrote: What formula is used to convert decimal degrees to circular degrees (deg,min,sec) and visa versa? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert decimal degrees to circular degrees (deg,min,sec)
Excerpt: Format the cell as [hh]:mm:ss to properly display values such as 107:30:45. Benn-at-Bax wrote: When I do this, the "dd" represents DAYS not degress so the conversion result always shows a max of "30" or "31" for degrees then goes back to 1. "Gary''s Student" wrote: for a really good discussion see: http://www.cpearson.com/excel/latlong.htm -- Gary''s Student - gsnu200719 "Benn-at-Bax" wrote: What formula is used to convert decimal degrees to circular degrees (deg,min,sec) and visa versa? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert decimal degrees to circular degrees (deg,min,sec)
You shouldn't be using dd in the format of the cell.
I suggest you re-read the page referred to. -- David Biddulph "Benn-at-Bax" wrote in message ... When I do this, the "dd" represents DAYS not degress so the conversion result always shows a max of "30" or "31" for degrees then goes back to 1. "Gary''s Student" wrote: for a really good discussion see: http://www.cpearson.com/excel/latlong.htm "Benn-at-Bax" wrote: What formula is used to convert decimal degrees to circular degrees (deg,min,sec) and visa versa? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you convert decimal degrees to degrees minutes seconds | Excel Discussion (Misc queries) | |||
| how can i convert degrees/minutes/seconds to decimal degrees? | Excel Discussion (Misc queries) | |||
| Convert degrees at 'Minutes' format. i.e. 43° 22', to Decimal | Excel Discussion (Misc queries) | |||
| convert decimal degrees to degrees minutes seconds | Excel Discussion (Misc queries) | |||
| HOW DO I CONVERT ANGLES TO DECIMAL DEGREES | Excel Worksheet Functions | |||
Hybrid Mode
