如题所述
A1=34°15.32821655'
B1公式
=LEFT(A1,FIND("°",A1)-1)+SUBSTITUTE(RIGHT(A1,LEN(A1)-FIND("°",A1)),"'",)/60