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

¦h¤u§@ªí¬Û³sµ²

¦^´_ 1# ws2315


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

§A¸Õ¸Õ¬Ý

TOP

¦^´_ 31# fengetianxia


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

TOP

¦^´_ 32# ws2315


    ´ú¸ÕªíB(2).zip (26.56 KB)
¹A¾ä,§A¸Õ¸Õ¬Ý

TOP

¦^´_ 33# fengetianxia


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

TOP

¦^´_ 34# ws2315


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

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

TOP

¦^´_ 35# fengetianxia


    ÁÂÁÂF¤j

TOP

¦^´_ 19# ML089


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

´ú¸Õ.rar (5.13 KB)

TOP

¦^´_ 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)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 38# ML089


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

TOP

¦^´_ 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¥[Á`

´ú¸Õ.rar (5.5 KB)

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD