Converting to Decimal degree's
Here is a neat trick:
Excel treats (degree:min:sec) just like (hour:min:sec) Enter: 30:20:15 in A1 and Excel will think it is time. In another cell enter: =A1*24 and format as general and you will see: 30.3375 -- Gary's Student "Charm" wrote: Im trying to convert a (degree:min:sec) field to decimal degrees. Someone please help me out. |
All times are GMT +1. The time now is 05:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com