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

[µo°Ý] ¥ð®§¤u®É­pºâ¡A½Ð¦U¦ì¤j®vÀ°¦£

[µo°Ý] ¥ð®§¤u®É­pºâ¡A½Ð¦U¦ì¤j®vÀ°¦£

À°¬Ý¬ÝªþÀÉ¡C¦]¬°³£­n­pºâ¤@­Ó¤ë¥÷ªº¡C¤j·§Á|¨Ò¤T¤Ñ¡C
­n¦p¦ó¼g¨ç¼Æ­pºâ·í¤Ñ¦boffice¸òfab®É¼Æ,¸ò¤@¾ã­Ó¤ë¥­§¡®É¼Æ¡C ¤u®É.pdf (88.18 KB)

¦^´_ 1# Qektyyrwp


    ¤£¦n·N«ä¡C¥Î¿ùÀÉ ¤u®É.zip (5 KB)

TOP

¦^´_ 2# Qektyyrwp


office¸òfab¦p¦ó°Ï¤À? °²³]¬O F2§PÂ_ "office"/"fab"
D2 =IF(AND($C2="out",$F2="office"),A2-A1,"")
E2 =IF(AND($C2="out",$F2="fab"),A2-A1,"")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¤£¦n·N«ä¡CD¸òEÄæ¦ì³£¬O­ì¥»¦³ªº¡C ¤u®É.zip (12.89 KB) À°¨DHÄæ¦ì

TOP

¦^´_ 4# Qektyyrwp


H2 =SUMPRODUCT((G2=INT(A$2:A$2400))*D$2:E$2400)
H31 =AVERAGE(OFFSET(H$2,,,ROW()-2))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¤£¦n·N«ä¡A¦b½Ð±Ð¤@¤U¡A¦pªG¬O¸ó¤éªº¸Ü¡AHÄæ¦ì¸Ó«ç»ò¼g¡A¤u§@®É¶¡¬°19:30~¹j¤Ñ07:30 ¡AD ¸òE ¤@¼Ë³£­ì¥»´N¦³

TOP

¦^´_ 7# Qektyyrwp

HÄæ¬O²Î­pD¡BEÄæ¦ì

©Ò¥HÀ³¸Ó¬OD¡BEÄæ¦ìªº®É¶¡­pºâ­n¥¿½T

¤@¯ë¸ó¤é­pºâ¥i¥H¥Î MOD(µ²§ô®É¶¡ - ¶}©l®É¶¡, 1)

PS: µ²§ô®É¶¡¡B¶}©l®É¶¡¬O«üEXCELªº®É¶¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# Qektyyrwp

¤]¥i¥H¥ÑAÄ檽±µ­pºâ

H2 =SUMPRODUCT(MOD(A$3:A$19-A$2:A$18,1)*MOD(ROW($3:$19),2)*(G2=INT(A$2:A$18)))*24
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 9# ML089


    ÁÂÁ§A

TOP

        ÀR«ä¦Û¦b : ¦¨¥\¬OÀuÂIªºµo´§¡A¥¢±Ñ¬O¯ÊÂIªº²Ö¿n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD