ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

°ê©w°²¤é©M¹j¶g¥ð¬°¤°»ò¨S¦³§@¥Î

°ê©w°²¤é©M¹j¶g¥ð¬°¤°»ò¨S¦³§@¥Î

=IF($A5="","",IF(OR($D5="",($C5>=6)+COUNTIF(°ê©w°²¤é!$A:$A,$A5)),IF(($D5>$I$1),($D5-$I$1),0)))
°ê©w°²¤é©M¹j¶g¥ð¬°¤°»ò¨S¦³§@¥Î

½Æ»s -100¦~10¦Ò¶Ôªí.rar (59.9 KB)

celina710828

¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-10-12 10:29 ½s¿è

=IF($A12="","",IF(($C12>5)*ISEVEN(COUNTIF($C$5:C12,$C$5)) +($C12=7)+COUNTIF(°ê©w°²¤é!$A:$A,$A12),MAX(0,FLOOR(MAX(0,$E12-D12),1/24/2)*24*2-2),0))
§PÂ_¬O§_²Ä¤G¶gªº¶g¤»

TOP

¦^´_ 2# ANGELA

§Úªºexcelª©¥»¬°¢±¢¯¢¯¢²ªº¡A¤U¸ü­ì©lÀɮ׸g¹LÂà´««á¥X²{¦³¨Ç¥\¯àµLªkÅã¥Ü¡AÁöµM¸gÂà´«ª©¥»¥i¥H¥¿±`Ū¨ú¤º®e¡A¦ý¬O®M¥Î±zªº¤½¦¡«áA12¥X²{#NAME?
¤£ª¾¬O§_´N¬Oª©¥»Âà´«©Ò¤Þ°_ªº¡H­Y¬O¦¹¦]¯À¡A°w¹ïª©EXCEL«hA12ªº¤½¦¡¦p¦ó­×§ï©O¡H·Ð½Ð½ç±Ð¡AÁÂÁ¡I

TOP

¦^´_ 3# onegirl0204


    ISEVEN(COUNTIF($C$5:C12,$C$5))
  = mod(COUNTIF($C$5:C12,$C$5),2) =0

TOP

¤j¤j­Ì¡A§Ú¸Õ¹LÁÙ¬O¤£¦æ
celina710828

TOP

¦^´_ 4# ANGELA


   ¦b¢Ï¢°¢±¿é¤J =IF($A12="","",IF(($C12>5)*MOD(COUNTIF($C$5:C12,$C$5),2) +($C12=7)+COUNTIF(°ê©w°²¤é!$A:$A,$A12),MAX(0,FLOOR(MAX(0,$E12-D12),1/24/2)*24*2-2),0))
µ²ªG¥X²{0:00¡A½Ð±Ð¤½¦¡¬O§_­þ­Ó³¡¥÷¤S¦³¿ù»~©O¡HÁÂÁ¡I

TOP

¦^´_ 5# celina710828

G5=IF((WEEKDAY($A5,2)=6)*(MOD(COUNTIF($B$5:$B5,"¤»"),2)=1),0,IF((WEEKDAY($A5,2)>5)+ISNUMBER(MATCH($A5,°ê©w°²¤é!$A:$A,0)),MAX(0,FLOOR(MAX(0,$E5-$D5),1/24/2)*24*2-2),0))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD