¤u®Épºâ°ÝÃD(»Ý¦©°£¥ð®§®É¶¡)
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
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¤½¦¡
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
À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¤½¦¡
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 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¤½¦¡
|
|
|
|
|