- ©«¤l
- 67
- ¥DÃD
- 21
- ºëµØ
- 0
- ¿n¤À
- 94
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2011-3-9
- ³Ì«áµn¿ý
- 2013-1-17
|
¥»©«³Ì«á¥Ñ gong ©ó 2011-4-25 22:54 ½s¿è
°²¤é¥[¯Z(30¤Àp)§Ú§â¥¦¥[¤W°ê©w°²¤é¥i¬O¤£¦æ¬Oþ¸Ì¥X°ÝÃD¤F.
=IF($C5>5)+COUNTIF(°ê©w°²¤é!$A:$A,$A5),0,CEILING(MAX(0,FLOOR(MAX(0,$E5-$L$1),1/24/2)*24*2-2),0)
(û¤u¸ê®Æ) ¦~ÄÖf2=if(e2="","",DATEDIF(E2,TODAY(),"Y")"·³"&DATEDIF(E2,TODAY(),"ym"))&"Ó¤ë"
µo¥Í¿ù»~
½Ð°²¤Ñ¼Æ
=NETWORKDAYS(A5,A34,°ê©w°²¤é!A2:A14)-SUMPRODUCT((C5:C34<6)*(D5:D34<>""))+SUMPRODUCT((C5:C34<6)*(D5:D34<>"")*COUNTIF(°ê©w°²¤é!$A$2:$A$14,$A$5:$A$34))
µo¥Í¿ù»~
¦°h(30¤Àp)
¦p¦ó¸I¨ì°ê©w°²¤é©M¬P´Á¤»¬P´Á¤é¡AÈÅã¥Ü¬° 0 ©O?
g5=IF(($C5>=6)+COUNTIF(°ê©w°²¤é!$A:$A,$A5),0,CEILING(MAX(0,$P$1-$E5),1/24/2)*24*2)
¦°h¸I¨ì°ê©w°²¤é¬O¥i¥H¤F¦ý¥¤é½Ð°²·|¥X²{34ªºÈ
I am sorry:( µ¹¤j¤j±z¶K³Â·Ð¤F) |
|