求助各位大侠

wisoon

因单位考勤需要，人多量大，如何将下表中进行转换，还望大家指导，谢谢！

hcm19522

E4:CQ8{=IFERROR(TEXT(SMALL(IF(('7'!$A$2:$A$146*1=--$A4)*(DAY('7'!$C$2:$C$146)=INT((COLUMN(C1)-1)/3)+1),MOD('7'!$C$2:$C$146,1))+ROW($2:$146),MATCH(MOD(COLUMN(C1)-1,3)+1,('7'!$A$2:$A$146*1=--$A4)*(DAY('7'!$C$2:$C$146)=INT((COLUMN(C1)-1)/3)+1)*MMULT((MOD('7'!$C$2:$C$146,1)>{0,11,16}/24)*1,{1;1;1}),)),"HH:MM"),"缺勤")

wisoon

hcm19522 发表于 2016-8-12 21:02
E4:CQ8{=IFERROR(TEXT(SMALL(IF(('7'!$A$2:$A$146*1=--$A4)*(DAY('7'!$C$2:$C$146)=INT((COLUMN(C1)-1)/3)+ ...

感谢您的指导，貌似这样的公式进去得不到完整的结果呢！