=LEFT(A1,FIND("°",A1)-1)+MID(A1,FIND("°",A1)+1,FIND(CHAR(39),A1)-1-FIND("°",A1))/60+MID(A1,FIND(CHAR(39),A1)+1,FIND(CHAR(34),A1)-1-FIND(CHAR(39),A1))/60/60
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(H2,"°",":"),"′",":"),"″",)*24
原文：http://www.cnblogs.com/gispathfinder/p/5769970.html