发布网友 发布时间:2022-02-26 02:45
共4个回答
热心网友 时间:2022-02-26 04:31
=HOUR(SUBSTITUTE(A1,"'",":"))*60+MINUTE(SUBSTITUTE(A1,"'",":"))热心网友 时间:2022-02-26 06:06
=substitute(a1,"'",":")*24*60热心网友 时间:2022-02-26 07:57
=LEFT(A1,FIND("'",A1)-1)*60+MID(A1,FIND("'",A1)+1,LEN(A1))热心网友 时间:2022-02-26 10:05
=--left(a1,find("'",a1)-1)*60+mid(a1,find("'",a1)+1,2)