Excel时分秒转换为分怎么转换
发布网友
共2个回答
热心网友
以小数表示，B1公式：（以原数据中h、m、s后有一个空格设计公式）
=IF(ISNUMBER(FIND("m ",A1)),SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"h ",":"),"m ",":",1),"s ",".",1),"ms",""),"0:"&SUBSTITUTE(SUBSTITUTE(A1,"s ",".",1),"ms",""))*24*60
下拉。
热心网友
你前两天不是问过这个问题了么？还没解决么？http://zhidao.baidu.com/question/561730866028304524
