=LEFT(I2,FIND("°",I2)-1)+(MID(I2,FIND("°",I2)+1,FIND("′",I2)-FIND("°",I2)-1)+MID(I2,FIND("′",I2)+1,LEN(I2)-FIND("′",I2)-1)/60)/60
转载于:https://www.cnblogs.com/chinhr/archive/2012/11/26/2788536.html
转载于:https://www.cnblogs.com/chinhr/archive/2012/11/26/2788536.html