¦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}))))
¶}§¹¤uªí³æ.zip (9.95 KB)
|