怎么将经纬度度分秒格式在EXCEL中转换成十进制
发布网友
发布时间：2022-04-20 00:02
共2个回答
热心网友
时间：2023-07-10 10:20
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B1,"°",":"),"′",":"),"″",)*24
追问我在E列输入=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C1,"°",":"),"′",":"),"″",)*24 显示的就是这个公式追答
网页链接
热心网友
时间：2023-07-10 10:20
云阳馆与韩绅宿别(司空曙)
