度提取
=LEFT(F24,FIND("°",F24)-1)
分提取
=MID(F24,FIND("°",F24)+1,FIND("′",F24)-FIND("°",F24)-1)/60
秒提取
=MID(F24,FIND("′",F24)+1,FIND("″",F24)-FIND("′",F24)-1)/3600
EXCEL经纬度 度分秒转换为度
最新推荐文章于 2024-04-03 01:13:00 发布
度提取
=LEFT(F24,FIND("°",F24)-1)
分提取
=MID(F24,FIND("°",F24)+1,FIND("′",F24)-FIND("°",F24)-1)/60
秒提取
=MID(F24,FIND("′",F24)+1,FIND("″",F24)-FIND("′",F24)-1)/3600