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

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

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