D2{=SUM(IFERROR(--MID(TEXT(MID(SUBSTITUTE(B2,"小",REPT(" ",9)),ROW($1:99),9),),2,3),))
另解{=SUM((LEN(B2)+1>LEN(SUBSTITUTE(";"&B2,";"&COLUMN(A1:AE1)&"号旷工"&ROW($1:2400)%&"小","")))*ROW($1:2400)%)
另解{=SUM(IFERROR(--MID(TEXT(MID(SUBSTITUTE(B2,"小时"," "),ROW(1:99),4),),2,8),))
另解{=SUM(--TEXT(MID(TEXT(RIGHT(TRIM(MID(SUBSTITUTE(B2,"小",REPT(" ",99)),ROW($1:5)*99-98,99)),{1,2,3,4}),),2,9),"0.0;;;!0"))
留言
張貼留言