excel表格请假半天怎么算

1.EXCEL请假时数计算

在I3输入： =8*INT(G3+H3-E3-F3-SUMPRODUCT(--(TEXT(ROW(INDIRECT(E3&":"&G3)),"AAA"）={"六"，"日"}）））+24*(H3+SUMPRODUCT((H3<--{"10:00","11:30","15:00"})*{"0:10","1:00","0:10"})-(F3+SUMPRODUCT((F3<--{"10:00","11:30","15:00"})*{"0:10","1:00","0:10"}））） 下拉填充。