https://jingyan.baidu.com/article/1974b2898910aff4b1f77414.html 1.度分秒转换 =MID(T2,1,3)+MID(U2,1,2)/60+MID(V2,1,4)/3600