Question

excel 角度到数值

86°15′45″108°3′37″100°1′4″86°31′7″100°47′2″110°57′13″115°6′38″114°59′2″124°57′12″

Answer 1

B1=--LEFT(A1,FIND("°",A1)-1)+(--MID(A1,FIND("°",A1)+1,FIND("′",A1)-FIND("°",A1)-1)/60)+(--MID(A1,FIND("′",A1)+1,FIND("″",A1)-FIND("′",A1)-1)/3600)
下拉
86°15′45″ 86.2625
108°3′37″ 108.0602778
100°1′4″ 100.0177778
86°31′7″ 86.51861111
100°47′2″ 100.7838889
110°57′13″ 110.9536111
115°6′38″ 115.1105556
114°59′2″ 114.9838889
124°57′12″ 124.9533333

Answer 2

假定数据在A列
B1公式:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"″",),"′",":"),"°",":")*24
向下填充