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

celina710828

=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¦³§@¥Î

ANGELA

=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¤»

onegirl0204

¦^´_ 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

ANGELA

¦^´_ 3# onegirl0204


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

celina710828

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

onegirl0204

¦^´_ 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

Hsieh

¦^´_ 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))