Excel - convert decimal to sexagesimal

Asked By theorrix on 19-May-10 02:28 AM
How can i type into an excell cell with decimal degrees and get common
degrees minutes and seconds




Phil Hibbs replied to theorrix on 19-May-10 05:51 AM
http://support.microsoft.com/kb/213449

Phil Hibbs.
helene and gabor replied to theorrix on 19-May-10 06:17 AM
Hello,

Type a number say in A1, the first digit is: (say in C1)   =INT(A1/60)
the second digit (could be multiple) is: A1-C1*60

best regards,

Gabor Sebo
------------------------------------------------------------------------------------------------------------------------------------------------------------------
----- Original Message -----
Newsgroups: microsoft.public.excel.programming
Sent: Wednesday, May 19, 2010 2:28 AM
Subject: convert decimal to sexagesimal