经度 | 纬度 | 转换经度 | 转换纬度 |
---|---|---|---|
122° 10′2.380″ | 37°24′53.689″ | =LEFT(B6,FIND(“°”,B6)-1)+(MID(B6,FIND(“°”,B6)+1,FIND(“′”,B6)-1-FIND(“°”,B6)))/60+(MID(B6,FIND(“′”,B6)+1,FIND(“″”,B6)-1-FIND(“′”,B6)))/3600 | =LEFT(C6,FIND(“°”,C6)-1)+(MID(C6,FIND(“°”,C6)+1,FIND(“′”,C6)-1-FIND(“°”,C6)))/60+(MID(C6,FIND(“′”,C6)+1,FIND(“″”,C6)-1-FIND(“′”,C6)))/3600 |
经度
=LEFT(B6,FIND("°",B6)-1)+(MID(B6,FIND("°",B6)+1,FIND("′",B6)-1-FIND("°",B6)))/60+(MID(B6,FIND("′",B6)+1,FIND("″",B6)-1-FIND("′",B6)))/3600
纬度
=LEFT(C6,FIND("°",C6)-1)+(MID(C6,FIND("°",C6)+1,FIND("′",C6)-1-FIND("°",C6)))/60+(MID(C6,FIND("′",C6)+1,FIND("″",C6)-1-FIND("′",C6)))/3600