A1数据5°23'3"B1公式=TEXT(--SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"°",":"),"'",":"),"""",),"h.mmss")后面的公式A2数据B2公式(但结果很显然是5.2306)=ROUND(INT(A2)+MOD(A2,1)*0.6,4)
