Home |
Search |
Today's Posts |
#1
|
|||
|
|||
converting from digital degrees to degrees minutes seconds
I need to convert latitudes and longitudes from digital degrees ( as 23.36
º) to degrees minutes seconds (as 23º 39' 38'') I found a way to do it for latitudes ( dividing by 24 and choosing hh:mm:ss format) but doesnt' work for longitudes ( I tried dividing by 48 instead considering the difference between 90 degres for latitud and 180 degrees for longitud, but doesn't work, either) The second problem I have is when I import GPS files with coordinates from CSV files, I always get digital degrees, yet those files have both options (digital degrees and degrees minutes seconds) |
#2
|
|||
|
|||
Visit
http://www.cpearson.com/excel/latlong.htm -- Kind Regards, Niek Otten Microsoft MVP - Excel "Patricio Boric" wrote in message ... I need to convert latitudes and longitudes from digital degrees ( as 23.36 º) to degrees minutes seconds (as 23º 39' 38'') I found a way to do it for latitudes ( dividing by 24 and choosing hh:mm:ss format) but doesnt' work for longitudes ( I tried dividing by 48 instead considering the difference between 90 degres for latitud and 180 degrees for longitud, but doesn't work, either) The second problem I have is when I import GPS files with coordinates from CSV files, I always get digital degrees, yet those files have both options (digital degrees and degrees minutes seconds) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enter minutes and seconds (lap times)? | Excel Discussion (Misc queries) | |||
Calculate commissions | Excel Worksheet Functions | |||
Minutes to seconds - how to convert? | Excel Worksheet Functions |