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

Comments