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

¤u®É­pºâ°ÝÃD(»Ý¦©°£¥ð®§®É¶¡)

¤u®É­pºâ°ÝÃD(»Ý¦©°£¥ð®§®É¶¡)

¤W¯Z®É¶¡08:00
¤U¯Z®É¶¡17:00
¤W¤È¥ð®§10:00 - 10:10
¤¤¤È¥ð®§12:00 - 13:00
¤U¤È¥ð®§15:00 - 15:10
±ß¤W¥ð®§17:00 - 17:20

¦pªþ¥ó,
Àx¦s®æI2 ¤u®É(¤À) ¬°¤°»ò·|¦h1¤ÀÄÁ?
Àx¦s®æI15 #REF! ¦p¦ó¤£Åã¥Ü?

¡·¤u®É­pºâ.rar (20.09 KB)

I2 =IF(PRODUCT(F2:G2),SUMPRODUCT(LOOKUP(ROW(INDIRECT(ROUND(F2*1440,0)&":"&ROUND(G2*1440-1,0))),{0,"8:00","10:00","10:10","12:00","13:00","15:00","15:10","17:00","17:20"}*1440,{0,1,0,1,0,1,0,1,0,1})),"")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

Àx¦s®æI2 ¤u®É(¤À) ¬°¤°»ò·|¦h1¤ÀÄÁ?
¦^ÂÐ: ®É¶¡*1440¨Ã«D¾ã¼Æ¡A®e©ö¦³¤p¼Æ»~®t¡C

Àx¦s®æI15 #REF! ¦p¦ó¤£Åã¥Ü?
¦^ÂÐ: °Ñ¦Ò#1ªº IF(PRODUCT(F2:G2), °õ¦æ, "")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

Àx¦s®æI2 ¤u®É(¤À) ¬°¤°»ò·|¦h1¤ÀÄÁ?
¦^ÂÐ: ®É¶¡*1440¨Ã«D¾ã¼Æ¡A®e©ö¦³¤p¼Æ»~®t¡C

Àx¦s®æI15 #REF! ¦p¦ó ...
ML089 µoªí©ó 2015-3-17 15:49



    ·PÁÂML089¤j¤jªº¸Ñµª, ½Ð°ÝI2Àx¦s®æªº®É¶¡¬O§_¥i¥H¦bB8-B17©w¸q, ²[¼Æ¤ºªº®É¶¡ª½±µ«ü©wÀx¦s®æ©O?

TOP

¦^´_ 4# 074063

=IF(PRODUCT(F2:G2),SUMPRODUCT(LOOKUP(ROW(INDIRECT(ROUND(F2*1440,0)&":"&ROUND(G2*1440-1,0))),A$20:B$29*{1440,1})),"")

{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_  074063

=IF(PRODUCT(F2:G2),SUMPRODUCT(LOOKUP(ROW(INDIRECT(ROUND(F2*1440,0)&":"&ROUND(G2*144 ...
ML089 µoªí©ó 2015-3-17 22:24



    ·PÁ¸ѵª :)

TOP

        ÀR«ä¦Û¦b : µêªÅ¦³ºÉ¡D§ÚÄ@µL½a¡AµoÄ@®e©ö¦æÄ@Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD