加班費 分三狀況與各階段 (14544)

E3=ROUND(SUM(TEXT(D3-N(OFFSET(H$2,{0;1;2},{0,2,4})),"0.0;!0;0")*(N(OFFSET(K$2,{0;1;2},{0,2,4}))-N(OFFSET(I$2,{0;1;2},{0,2,4})))*(IF(COUNTIF(G:G,B3),3,(WEEKDAY(B3,2)>5)+1)={1;2;3}))*A$3/240,)