WPS或EXCEL度分秒和十进制度之间的转换
C3 B3是你之前要改变的数
度分秒转十进制:
=LEFT(C3,FIND(“°”,C3)-1)+MID(C3,FIND(“°”,C3)+1,FIND("′",C3)-FIND(“°”,C3)-1)/60+MID(C3,FIND("′",C3)+1,FIND("″",C3)-FIND("′",C3)-1)/3600
十进制转度分秒:
=TEXT(INT(B3),“0”)&“°”&TEXT(INT((B3-INT(B3))*60),“00”)&"′"&TEXT(((B3-INT(B3))*60-INT((B3-INT(B3))*60))*60,“00.0000”)&"″"