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

[µo°Ý] ¶}©l®É¶¡»Pµ²§ô®É¶¡ºâªk

[µo°Ý] ¶}©l®É¶¡»Pµ²§ô®É¶¡ºâªk

¦U¦ì¥ý¶i¦n
¤p§Ì¦³¤@°ÝÃD·Q½Ð±Ð
Sum  offset  lookup ¥h°µ¤F¤@±iªíÅý¨ä¤u®É¯à¦Û°Ê²Î­pªí³æ
¦ý³Â·Ðªº¬O¦]¬°¬O24¤p®É­pºâ¦³¨Çºâ¤£¥X¨Ó
¶W¹L00:00¤p§Ì¦³¥[1 ¦ýºâ¥X¨Óªº­ÈÁÙ¬O¤£¹ï
Àµ½Ð¸Ñ´b!!
·PÁÂ!!
¤½¦¡¦p¤U
H2==IF(G2>F2,($G2-$F2)*60*24,(($G2+1)-($F2))*60*24)+SUM(OFFSET($C$2,,,LOOKUP(VALUE($F2),$B$2:$B$11,{1,2,3,4,5,6,7,8,9,10})))-IF(G2>F2,SUM(OFFSET($C$2,,,LOOKUP(VALUE($G2),$B$2:$B$11,{1,2,3,4,5,6,7,8,9,10}))),SUM(OFFSET($C$2,,,LOOKUP(VALUE($G2+1),$B$2:$B$11,{1,2,3,4,5,6,7,8,9,10}))))
2019-06-27 20_42_22.jpg
2019-6-27 20:42

¶}§¹¤uªí³æ.zip (9.95 KB)

¦^´_ 2# ­ã´£³¡ªL

¤j¤j±z¦n!!
¶}§¹¤uªí³æ.zip (7.73 KB)
­«¶Ç¤Fªþ¥ó
¤º®e»P­ì´£°Ýªº¹Ï¤ù¤@¼Ë¡A¦A³Â·Ð½T»{¤@¤U
·PÁ±zªºÀ°¦£!!

TOP

¦^´_ 4# ­ã´£³¡ªL


    ÁÂÁ ­ã´£³¡ªL ¤j¤j
³o¤½¦¡ ¤ñ§Ú¤§«eÁÙ²`¿D
¦³ÂI¬Ý¤£¤ÓÀ´  
»Ý­nÂI®É¶¡¤F¸Ñ

TOP

¦^´_ 4# ­ã´£³¡ªL

­ã´£³¡ªL¤j ±z¦n
¤p§Ì¹Á¸Õ¤F¥h¥Î ±z«Øijªº¤½¦¡¥h­×§ï

¨Ã¹Á¸Õ°µ¤FÀx¦s®æ¸ò¦ì¸mªº­×¥¿¡A¦ý³£±o¤£¨ì¤@­Óµª®×
ªþ¥ó~½Ð°Ñ¦Ò
¶}§¹¤u®É¶¡A.zip (41.65 KB)
·Q½Ð°Ý!!
§Ú¤w¸g§â½d³òªºROWªº½d³ò¥[¤j¤F¬°¦óÁÙ·|¿ù»~!?
SMALL ¤w¸g§ì¨ì¤F¬Û¹ïªº¦ì¸m
¦ýLookup «o§ì¤£¨ì
¯uªº¤£¤ÓÀ´³o¤½¦¡ªº·N«ä

³Â·Ð±z¸Ñ´b!!ÁÂÁÂ!!

TOP

¦^´_ 7# ­ã´£³¡ªL


   ¦nªº!!«D±`·PÁ ­ã´£³¡ªL¤jªº¦^ÂÐ !!

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD