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?

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?

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?

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?

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?