如何在EXCEL里进行经纬度转换?
如果经度格式是28°28'562",要在EXCEL表格里转换成28.62278格式的,并且保留相应的小数点位数,请问公式是什么?
我的意思是如果A1单元格输入28°28'562",如果在B1单元格转换成28.62278度!
人气:138 ℃ 时间:2020-05-15 03:41:03
解答
=LEFT(A1,FIND("°",A1)-1)+MID(A1,FIND("°",A1)+1,FIND("'",A1)-FIND("°",A1)-1)/60+MID(A1,FIND("'",A1)+1,LEN(A1)-FIND("'",A1)-1)/3600
推荐
猜你喜欢
- 守株待兔文言文翻译
- 如何计算RC并联电路周期
- she is on a special_to lose_weight.
- 用介词填空 jim kept [ ]thinking about the football match in the afternoom
- 在以d为公差的等差数列(an)中,设S1=a1+a2+...+an,S2=a(n+1)+a(n+2)+...+a(2n),S3=a(2n+1)+a(2n+2)+...+a(3n),求证S1,S2,S3也是等差数列,并求其公差
- ,The old man has three sons,two of ( )are working in the hospital.选WHOM,是 任何介词后面都选whom
- the boy is five 对后一个单词提问
- do a survey,then make a chart