ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Conversions (https://www.excelbanter.com/excel-worksheet-functions/130571-conversions.html)

dengel

Conversions
 
Does anyone know how to convert degree/minutes/seconds to decimal degrees in
an excel spreadsheet???????

36°13'53.23" should equal 36.23145277...
Any help would be appreciated.

John

Conversions
 
This might help you
http://support.microsoft.com/kb/213449
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"dengel" wrote:

Does anyone know how to convert degree/minutes/seconds to decimal degrees in
an excel spreadsheet???????

36°13'53.23" should equal 36.23145277...
Any help would be appreciated.


David Biddulph

Conversions
 
http://www.cpearson.com/excel/latlong.htm
--
David Biddulph

"dengel" wrote in message
...
Does anyone know how to convert degree/minutes/seconds to decimal degrees
in
an excel spreadsheet???????

36°13'53.23" should equal 36.23145277...
Any help would be appreciated.





All times are GMT +1. The time now is 05:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com