統計出勤時數 (10663)

日期：


I3:L6{=SUM(IFERROR(SUBSTITUTE(TRIM(MID(SUBSTITUTE($B3:$H3,"/",REPT(" ",9)),{1;10},9)),CHOOSE(COLUMN(A1),"出勤","事","加","休加"),)*1,))


留言

張貼留言