fengetianxia

¦^´_ 1# ws2315


    ´ú¸ÕªíA.zip (7.76 KB)

¤U¸ü¦¸¼Æ: 4

2017-3-6 16:19

§A¸Õ¸Õ¬Ý

ws2315

¦^´_ 31# fengetianxia


    ·PÁÂF¤j  ¥ý¸Õ¸Õ

fengetianxia

¦^´_ 32# ws2315


    ´ú¸ÕªíB(2).zip (26.56 KB)

¤U¸ü¦¸¼Æ: 5

2017-5-17 18:36

¹A¾ä,§A¸Õ¸Õ¬Ý

ws2315

¦^´_ 33# fengetianxia


   «D±`·PÁÂF¤j,¥ý¸Õ¸Õ¬Ý

fengetianxia

¦^´_ 34# ws2315


    ´ú¸ÕªíB(2).zip (26.49 KB)

¤U¸ü¦¸¼Æ: 2

2017-5-22 17:07

§A¸Õ¸Õ¬Ý,¤£¹L³o¥÷À³¸Ó¥u¯à¥Î¨ì¤½¾ä2021¦~ªº2¤ë11¸¹

ws2315

¦^´_ 35# fengetianxia


    ÁÂÁÂF¤j

ws2315

¦^´_ 19# ML089


    ¦p®É¶¡§ï¬°23001~0700   0701~1500 1501~2300
   ½ÐM¤j±Ð¾É,ÁÂÁÂ

ML089

¦^´_ 37# ws2315


    I12 =SUMPRODUCT((MOD(B$3:B$74-701,2400)>=MOD(MID($H12,3,4)-701,2400))*(MOD(B$3:B$74-701,2400)<=MOD(MID($H12,8,4)-701,2400)),C$3:C$74)

ws2315

¦^´_ 38# ML089


    ·PÁÂM¤j,¥ý¸Õ¸Õ

ws2315

¦^´_ 38# ML089

¥i¥H½ÐM¤j©Î¦U°ª¤â¤W¶ÇÀÉ®×,·PÁÂ

¨Ò¦p¨t²Î¤é´Á¬°108¦~1¤ë18¤é(§Y¨Ì¨t²Î®É¶¡§ì¤u§@ªí·í¤Ñ¤é´Á)
Sheet2 B3 §ìShee1 108¦~1¤ë21¤é,®É¶¡¬°2301~0700,¼Æ¶q¥[Á`
Sheet2 B1 §ìShee1 108¦~1¤ë21¤é,®É¶¡¬°0701~1500,¼Æ¶q¥[Á`
Sheet2 B2 §ìShee1 108¦~1¤ë21¤é,®É¶¡¬°1501~2300,¼Æ¶q¥[Á`