How to convert decimal angles from or to degrees/minutes/seconds in Excel

admin ExcelComments1,040Read

convert decimal angles to degrees/minutes/seconds

=TEXT(INT(A1),"0")&"°"&TEXT(INT((A1-INT(A1))*60),"00")&"′"&TEXT(((A1-INT(A1))*60-INT((A1-INT(A1))*60))*60,"00.0000")&""""

convert degrees/minutes/seconds to decimal angles文章源自LuckYou.ORG-https://luckyou.org/202.html

=LEFT(B1,FIND("°",B1)-1)*1+MID(B1,FIND("°",B1)+1,2)/60+MID(B1,FIND("′",B1)+1,LEN(B1)-FIND("′",B1)-1)/3600
文章源自LuckYou.ORG-https://luckyou.org/202.html文章源自LuckYou.ORG-https://luckyou.org/202.html
 
匿名

Comment

Anonymous

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

Decide