LinkBack URL
About LinkBacks
Dear Expert,
I am looking for a formula to convert Decimal Degrees (DD) into Degrees Minutes Seconds (DMS) in excel sheet.
Sample Sheet is attached please....
Example:
DD : 52.635
DMS: 52°38'6''
Please help me in this regard.
Regards
Rahmatullah
Dear Expert,
I am looking for a formula to convert Decimal Degrees (DD) into Degrees Minutes Seconds (DMS) in excel sheet.
Sample Sheet is attached please....
Example:
DD : 52.635
DMS: 52°38'6''
Please help me in this regard.
Regards
Rahmatullah
Last edited by Reahmatullah Ktk; 04-07-2022 at 04:08 PM. Reason: Attaching sample sheet
try
degrees in A1
82.354
Minutes
in B1
=(mod(A1,1)*60)
=21.24
seconds
in C1
=mod(B1,1)*60
=14.40
so final result
is =INT(A1) & INT(B1) & C1
Last edited by JohnTopley; 04-07-2022 at 04:25 PM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Minutes & Seconds are OK, Degree Formula is not working?????Originally Posted by JohnTopley
Last edited by Reahmatullah Ktk; 04-07-2022 at 04:15 PM.
To get degrees you just need INT(A1). Like John put in the last line.
See attached
UPDATED: with your file
Last edited by JohnTopley; 04-07-2022 at 04:46 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks