时 分 秒轉換數字 (9434)

时 分 秒均有=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"小时",":"),"分",":"),"秒",)*24

另解{=IFERROR(LEFT(A2,FIND("小",A2)-1),)+SUM(IFERROR(MIDB(0&A2,FINDB({"分","秒"},0&A2)-2,2)*60^{-1,-2},))

另解=IFERROR(LEFT(A2,FIND("小",A2)-1),)+MMULT(MIDB(0&A2&"000",FINDB({"分","秒"},0&A2&"0分0秒")-2,2)*1,60^{-1;-2})