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

¦³Ãö¥[¯Z¶O­pºâ¤Î¤é´ÁÅã¥Üªº°ÝÃD½Ð¤j®aÀ°¦£

¦³Ãö¥[¯Z¶O­pºâ¤Î¤é´ÁÅã¥Üªº°ÝÃD½Ð¤j®aÀ°¦£

¦³Ãö¥[¯Z¹L24:00ÂIÀ³¸Ó¦p¦ó²Ö­p,©M¤é´ÁÅã¥Ü¤§¤½¦¡°ÝÃD

Á~¸ê.rar (11.42 KB)

chaoping22

¤é´Á¤½¦¡¡A¥i¸Õ¸Õ¤U¦Cªº¤½¦¡¡C
­Y¦³¥ô¦ó¿ùº|¡A½Ð¦U¤j¤j´£ÂI¡I
A31=IF(MONTH(DATE(YEAR($J$1),MONTH($J$1),29))=MONTH($J$1),29,"")
A32=IF(MONTH(DATE(YEAR($J$1),MONTH($J$1),30))=MONTH($J$1),30,"")
A33=IF(MONTH(DATE(YEAR($J$1),MONTH($J$1),31))=MONTH($J$1),31,"")

·s¤B¦bExcel¤Wªº§Þ¥©¤Q¤À½§²L¡A¶È¯à±N¦Û¤v©Ò´¿À³¥Îªº§Þ¥©¡A»P¤H¤À¨É¡I

TOP

ÁÂÁÂtrainee ¤j¤j,¤é´Á¤½¦¡²Å¦X§Úªº»Ý¨D
chaoping22

TOP

¥´¥d®É¶¡À³¬OB:EÄ檺®É¶¡§a?
½Ð»¡©úF~JÄ檺¦UÄæ¥Î·N
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ gong ©ó 2011-6-11 10:51 ½s¿è

a31= IF(MONTH(A30+1)<> MONTH($K$1),"",A30+1)

a31= IF(MONTH(A30+1)<> MONTH($j$1),"",A30+1)

«ü©w¦ì¸m¿ù¤F
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

g~hÀ³¬O©]¯Z¥[¯Z
hÄæ¦h¤@Äæ§a
¦ph7=02:30
i7(»²§UÄæ)=if((g7>h7),h7+1,h7)
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

fÄæ19:00¬O¤°»ò·N«ä
¥[¯Z®É¼Æ¤£¬Oh-g¶Ü,»Pf¦³¦óÃö«Y
¦p¥Hh-f¬°°ò·Çºâ¥X¨Óªº¬O¤À,À³¸Ó¦A*60¤À*24¤p®É¤~¬O´X¤p®É©Ò¥H³o­Ó*1440¨S¿ù
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-6-11 21:46 ½s¿è

F3:F33¬O§Ú¦bL3­pºâ¥[¯Z¥Îªº¤½¦¡¬O{=SUM(($H$3:$H$33<>"")*($H$3:$H$33-$F$3:$F$33))}
F1~I1¬O¥Î¨Ó­pºâ¿ð¨ì©Î¦­°h¦¸¼Æªº¼Æ­È
chaoping22

TOP

§âªí®æ­×§ï¹L,¤ñ¸û²M·¡½Ð¦U¦ì¤j¤j¦b¬Ý¬Ý,À³¸Ó¦p¦ó­×§ï¤ñ¸û¥¿½T,ÁÂÁÂ!!

Á~¸ê.rar (11.65 KB)

chaoping22

TOP

19:00¬O¤W¯Zº¡¤K¤p®É,¥[¯Z®É¶¡H-F
chaoping22

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD