怎么将经纬度度分秒格式在EXCEL中转换成十进制

Question

求公式

Answer 1

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B1,"°",":"),"′",":"),"″",)*24

追问

我在E列输入=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C1,"°",":"),"′",":"),"″",)*24 显示的就是这个公式

追答

网页链接

本回答被提问者和网友采纳

Answer 2

云阳馆与韩绅宿别(司空曙)