字符時間改正式時間 (13468)

C2{=TEXT(SUM(IFERROR(RIGHTB(LEFT(B2,FIND({"小","分"},B2)-1),2),)/{24,1440}),"HH:MM")

另解=TEXT(IFERROR(RIGHTB(LEFT(B2,FIND("分",B2)-1),2),)/1440+IFERROR(RIGHTB(LEFT(B2,FIND("小",B2)-1),2),)/24,"HH:MM")

另解=TEXT(SUM((0&TRIM(MIDB(0&B2,FINDB({"小","分"},0&B2&"0小分")-2,2)))/{24,1440}),"HH:MM")