发布网友 发布时间:2022-04-20 00:02
共4个回答
热心网友 时间:2023-06-07 02:56
灞曞紑鍏ㄩ儴=LEFT(A1,2)+MID(A1,FIND("掳",A1)+1,2)/60+MID(A1,FIND("鈥?quot;,A1)+1,2)/3600热心网友 时间:2023-06-18 16:47
灞曞紑鍏ㄩ儴=LEFT(A1,2)+MID(A1,FIND("掳",A1)+1,2)/60+MID(A1,FIND("鈥?quot;,A1)+1,2)/3600热心网友 时间:2023-07-02 12:32
=LEFT(A1,2)+MID(A1,FIND("°",A1)+1,2)/60+MID(A1,FIND("′",A1)+1,2)/3600热心网友 时间:2023-07-02 12:32
在A1中输入度,在A2中输入分,在A3中输入秒,在A4中输入 =A1+A2/60+A3/3600热心网友 时间:2023-07-02 12:33
(INT(A11)+INT((A11-INT(A11))*100)/60+((A11*100-INT(A11*100))*100)/3600)热心网友 时间:2023-07-02 12:33
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"°",":"),"′",":"),"〃","")*24