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