I2:N5=IFERROR(TRIM(MID(SUBSTITUTE(SUBSTITUTE($B2&$C2&$D2," ",":"),":",REPT(" ",199)),COLUMN(A1)*398-199,199))&-LOOKUP(9,-RIGHT(TRIM(MID(SUBSTITUTE(MID($B2&"/"&$C2&"/"&$D2&"/",MATCH(1=1,$B2:$D2<>"",),999),"/",REPT(" ",199)),COLUMN(A1)*199-198,199)),{1,2})),"")
G2:G5{=SUM(IFERROR(SUBSTITUTE(I$2:N$5,F2,)*1,))
留言
張貼留言