第1个回答 2016-07-22
在B1中输入或复制粘贴下列公式
=IF(ISERROR(FIND("分",A1)),CEILING(--("0:0:"&SUBSTITUTE(A1,"秒",)),1/24/60),CEILING(--("0:"&SUBSTITUTE(SUBSTITUTE(A1,"分",":"),"秒",)),1/24/60))
下拉填充
第2个回答 2016-07-22
假设数据在A、B列,且A列是时间数据,不是文本数据
B1公式:=ROUNDUP(A1*24*60,0)
或A列是文本数据,则
B1公式:=ROUNDUP(TIMEVALUE("0:"&SUBSTITUTE(SUBSTITUTE(A1,"分",":"),"秒",""))*24*60,0)
第3个回答 2016-07-22
=CEILING(TEXT(IF(COUNTIF(A1,"*分*"),"0:","0:0:")&SUBSTITUTE(SUBSTITUTE(A1,"分",":"),"秒",""),"[s]"),60)/60