Decimal Degree to DegMinSec conversion? 
Author Message
 Decimal Degree to DegMinSec conversion?

I am a land surveyor. I find it necessary to convert
 Decimal Degrees to Degrees, Minutes and Seconds and vice
versa, yet I cannot find this function in Excel books or
the Help menu.  This is a standard key on an HP
calculator, I would think that EXCEL would handle it.

For example:

25 deg 30 min 15 sec= 25.50147 degrees

or

25.50147 degrees = 25 deg 30 min 15 sec

Any suggestions

PS I can put each in a separate cell and divide min by 60
and seconds by 3600, but I can't convert the other way.

Thanks

Mike



Fri, 04 Jun 2004 06:11:23 GMT  
 Decimal Degree to DegMinSec conversion?
See Chip Pearson's web site for some info on this:
http://www.cpearson.com/excel/latlong.htm
Quote:

> I am a land surveyor. I find it necessary to convert
>  Decimal Degrees to Degrees, Minutes and Seconds and vice
> versa, yet I cannot find this function in Excel books or
> the Help menu.  This is a standard key on an HP
> calculator, I would think that EXCEL would handle it.

> For example:

> 25 deg 30 min 15 sec= 25.50147 degrees

> or

> 25.50147 degrees = 25 deg 30 min 15 sec

> Any suggestions

> PS I can put each in a separate cell and divide min by 60
> and seconds by 3600, but I can't convert the other way.

> Thanks

> Mike



Fri, 04 Jun 2004 06:24:17 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Need conversion of Lat/Lon to decimal degrees

2. Need Formula to Convert Decimal Degrees to Degrees Minutes

3. convert from decimal degrees do degrees, minutes, seconds

4. Converting Degrees to Decimal Degrees

5. MATH: Decimal degrees to DMS

6. Converting decimal degrees to millimeters

7. Using and converting DMS to Decimal Degrees

8. decimal to degrees minutes seconds function

9. Using and converting DMS to Decimal Degrees

10. Decimal degrees


 
Powered by phpBB® Forum Software © phpBB Group