如果时间在A1单元格，那么在B1输入以下公式=LEFT(A1,FIND("分",A1)-1)*60+MID(A1,FIND("分",A1)+1,LEN(A1)-FIND("分",A1)-1)
=TEXT("00:"&SUBSTITUTE(SUBSTITUTE(A1,"分",":"),"秒",""),"[S]")
