convert decimal degrees to degrees minutes seconds

[Chris r]

im tryin to make a function in a cell and i want to know do i convert decimal
degrees to degrees minutes seconds

thanks

 

[jlucy]

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.

 

[Sandy Mann]

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
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk