Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert decimal degrees to degrees minutes seconds
im tryin to make a function in a cell and i want to know do i convert decimal
degrees to degrees minutes seconds thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert decimal degrees to degrees minutes seconds
I've used this:
A B FORMULA IN COLUMN B 1 Latitude in DD 39.89458898 2 minutes 53.67533862 =(B1-INT(B1))*60 3 seconds 40.5203172 =(B2-INT(B2))*60 4 converted to DMS 39d 53m 40.52032s =CONCATENATE(INT(B1),"d ",INT(B2),"m ",ROUND(B3,5),"s") you wouldn't need the "d " or "m " or "s" in the concatenate formula if you don't want or need them, and I wanted the seconds rounded to 5 decimal places so that is why the ROUND function. "Chris r" wrote: im tryin to make a function in a cell and i want to know do i convert decimal degrees to degrees minutes seconds thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert decimal degrees to degrees minutes seconds
AS there are sixty seconds in minutes and seconds in both angles and time
you can use Excels time format: Divide your decimal angle by 24 and format as [H]:mm-ss -- HTH Sandy Replace@mailinator with @tiscali.co.uk "Chris r" <Chris wrote in message ... im tryin to make a function in a cell and i want to know do i convert decimal degrees to degrees minutes seconds thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert decimal degree (lattitude/longitude) into Degree, | Excel Discussion (Misc queries) | |||
Create a custom format to convert seconds to minutes. | Excel Discussion (Misc queries) | |||
convert an angle to degrees minutes seconds | Excel Discussion (Misc queries) | |||
convert seconds to minutes and seconds | Excel Worksheet Functions | |||
converting from digital degrees to degrees minutes seconds | Excel Worksheet Functions |