=SUMPRODUCT(--(WEEKDAY(INT(A1)+ROW(INDIRECT("1:"&(INT(B1)-INT(A1))))-1,2)<6))-FLOOR(TEXT(IF(B1-INT(B1)>A1-INT(A1),B1-INT(B1)-(A1-INT(A1)),B1-INT(B1)-(A1-INT(A1))+"24:0"),"[h]")/24,0.5)
啥叫不完整的工作日？ 你这是计算工时啊！
