回复：函数问题你问我答，太难的不会

=IF(D92=8/24,B92+1,B92) 因为时间在Excel中是以小数表示一整天就是1，8点就是8/24天。

=SUM((T(OFFSET(Sheet2!B1,MATCH(A2:A7,Sheet2!A2:A7,),))="A")*(C2:C7=44105)*B2:B7) 三键

=ROUND(MOD(SMALL(ROUND(RAND(),4)*10^10+(ROW()-1)*8+COLUMN()-10,(ROW()-1)*8+COLUMN()-10),10000),0)
=TEXTJOIN("",1,IF($K$1:$R$25=SUM((ROW(A1)-1)*8+COLUMN(A1)),$A$1:$H$25,""))
方法不是能用，还需要优化，先将就用用

放到Word 处理了再复制回EXCEL

是 这样吗

=IF(ROW()<MATCH(E$1,$A:$A,)-MATCH(D$1,$A:$A,)+1,OFFSET($A$1,MATCH(D$1,$A:$A,)+ROW()-2,),"")

=IFERROR(VLOOKUP(LOOKUP(ROW(),IF($A$2:$A$10<>"",ROW($A$2:$A$10),""),$A$2:$A$10)&$B2,IF({1,0},$G$2:$G$7&$H$2:$H$7,I$2:I$7),2,0),"") 数组3键，然后填充

=IFERROR(OFFSET(B$1,LARGE(IF($B$2:$B$31=$L$2,ROW($B$2:$B$31),""),ROW(A1)),),"") 数组3键 在填充下拉

=SUM(IF((WEEKDAY($B$1:$M$1,2)<=5),IF($B2:$M2>8,8,$B2:$M2),0))
=SUM(IF((WEEKDAY($B$1:$M$1,2)<=5),IF($B2:$M2>=8,$B2:$M2-8,0),0))
=SUM(IF((WEEKDAY($B$1:$M$1,2)<=5),0,$B2:$M2)) 都是数组3键

=EVALUATE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A5,"k",""),"+","*1000+"),".","+0*"))&B5&EVALUATE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C5,"k",""),"+","*1000+"),".","+0*"))

=OR(ABS(A2-SUM(A1))<=3,ABS(SUM(A3)-A2)<=3) 把这个公式贴在条件格式了就可以符合条件的就变色了。这是与上下一个的差值小于等于3 就是显示true，其他就false。上下临界的单元格可能会出错，你要检查一下

正算很容易，按时间算感觉很难，明天试试转成解数学方程的方法试试