经纬度如何在EXCEL中的度分秒格式转换成度分格式的数据,如31°47'03...答:度分秒输在A1单元格,则公式 =LEFT(A1,FIND("°",A1)) & MID(A1,FIND("°",A1)+1,FIND("'",A1)-FIND("°",A1)-1)+MID(A1,FIND("'",A1)+1,FIND("''",A1)-FIND("'",A1)-1)/60 & "'"其中 LEFT(A1,FIND("°",A1)) 取度串 MID(A1,FIND("°",A1)+1,FIND("'...
excel中例如28 39 45 和208 39 48 这两个是度分秒,怎么怎么用excel加减...答:相加:=TEXT(SUBSTITUTE(B2," ",":")+SUBSTITUTE(A2," ",":"),"[h] m s")相减:=TEXT(SUBSTITUTE(B2," ",":")-SUBSTITUTE(A2," ",":"),"[h] m s")见下图: