MrExcel Publishing
Your One Stop for Excel Tips & Solutions

degrees minutes and seconds


Posted by neil white on December 10, 2001 4:41 AM

is there a way to convert a decimal degree to degrees minutes and second!!!

it's driving me batty!!

thanks
neil


Posted by Dan on December 10, 2001 7:10 AM

Here's a lengthy formula, assuming that your decimal number is in A1, place this formula in cell B1. For some reason, Excel seems to get messed up a little on the decimals when the formula is this long, so this is to the nearest tenth of a second.
=INT(A1) & " deg " & INT((A1-INT(A1))*60) & " ' " & ROUND(((A1-INT(A1))*60-INT((A1-INT(A1))*60))*60,1) & " ''"

If you need a more accurate number (i.e. more decimal numbers in the seconds portion, reply back and I can give you a slightly different method.

HTH