EXCEL中如何把23秒,1分23秒,3小时3分16秒都转换成以秒为单位的

我有个复杂点的公式,但是也能得出结果,凑合用吧。=IF(ISERROR(FIND("分",A1)),LEFt(A1,FIND("秒",A1)-1)*1,IF(ISERROR(FIND("小时",A1)),LEFt(A1,FIND("分",A1)-1)*60+MId(A1,FIND("分",A1)+1,FIND("秒",A1)-FIND("分",A1)-1),LEFt(A1,FIND("小时",A1)-1)*3600+MId(A1,FIND("小时",A1)+2,FIND("分",A1)-FIND("小时",A1)-2)*60+MId(A1,FIND("分",A1)+1,FIND("秒",A1)-FIND("分",A1)-1)))