convert decimal degrees to degrees minutes seconds

C

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
 
J

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.
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top