| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display a number that is decimal degrees in Deg:min:sec format | 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 | |||
| Distance between two GPS points (Decimal degrees) | Excel Worksheet Functions | |||
| converting from digital degrees to degrees minutes seconds | Excel Worksheet Functions | |||
Linear Mode
