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

[µo°Ý] «e´X¤Ñ¶]¤F¤@¦¸¡A¤Sµo²{·sªº°ÝÃD¤F

¦Û¤v¦A§V¤O¤@ÃD´N¥i¥H¤É¯Å¤F
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¥»©«³Ì«á¥Ñ gong ©ó 2011-4-28 22:11 ½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)

·PÁÂG¤j¡A§Ú°Ñ¦Ò¨ä¥¦Àx¦s®æ¥[¤W°ê©w°²¤é¡A¤w§¹¦¨¤F  °²¤é¥[¯Zªº³¡¥÷¡AÁÂÁÂ!:lol
=IF(A5="","",IF(($C5>5)+COUNTIF(°ê©w°²¤é!$A:$A,$A5),MAX(0,FLOOR(MAX(0,$E5-D5),1/24/2)*24*2-2),0))
celina710828

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD