度分秒转十进制:=SUBSTITUTE(SUBSTITUTE(LEFT(A1,LEN(A1)-1),"°",":"),"′",":")*24 十进制转度分秒:=TEXT(B3/24,"[h]°m′sss.000″")