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

¯S©w®É¶¡¦©°£

¯S©w®É¶¡¦©°£

¦p¦ó¦b¶}©l®É¶¡©Mµ²§ô®É¶¡²Î­p¡A¦b¨Ì¹ï·Óªíªº¶¥¬q©Ê¥ð®§®É¶¡®y¦©°£ªº²Î­p¡A«ô¨D¦Ñ®v­Ì¨D¸Ñ¡AÁÂÁÂ!!!
ªþÀÉ: 20160222.rar (6.7 KB)

¦©±¼¬í¡D­­µL¸ó¤é¡D¸Õ¬Ý¬Ý§a¡G
=SUM(FREQUENCY(ROW(INDIRECT(TEXT(A2,"h:m")*1440+1&":"&TEXT(B2,"h:m")*1440)),({12,13,17,17.5}+(C2="Yes")*24)*60)*{1;0;1;0;1})
1

µû¤À¤H¼Æ

    • ML089: FREQUENCY ¤ñ LOOKUP¦n¥Îª÷¿ú + 2

TOP

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

¯u¦hÁ·Ǥj¦Ñ®vªº¸ÑÃD¡A§¹¥þ¥¿½T¡A¤p§Ì¤§«e¬O§âµª®×¤À2Äæ­pºâ¡A·Q»¡¤W¨Ó¨Dª¾ÃѪø¶i¡AªGµM¤S¨£ÃѨ찪²`ªº¸ÑÃD¨ç¼Æ¡AFREQUENCY¦¹¨ç¼ÆÁÙ¥i³o¼ËÀ³¥Î¡A¯uªø¤Fª¾ÃÑ!ÁÂÁ·Ǥj¦Ñ®v¡A
¯¬¦Ñ®v:·s¦~§Ö¼Ö&¨­Åé°·±d&¤@¤Á¶¶¤ß!

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2016-2-24 00:16 ½s¿è

¦^´_ 1# man65boy

¥i¥H¸ó¤é¡Aª`·N¬í¼Æ·|¥|±Ë¤­¤J ©Î±N ROUND§ï¬°ROUNDDOWNª½±µ¥h¬í¼Æ

=SUM(FREQUENCY(MOD(A2+(ROW(INDIRECT("1:"&ROUND((B2-A2)*1440,0)))-1)/1440,1),G$2:H$3+(C2="Yes"))*{1;0;1;0;1})
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

ª`·N¡A¬í¼Æ·|¼vÅTµ²ªG

¤U¦¡¥ý¥h°£¬í¼Æ¦A¨ú¸g¹L®É¶¡
=SUM(FREQUENCY(MOD(A2+(ROW(INDIRECT("1:"&INT(B2*1440)-INT(A2*1440)))-1)/1440,1),G$2:H$3+(C2="Yes"))*{1;0;1;0;1})

¤U¦¡¥ý¨ú¸g¹L®É¶¡¦A¥h°£¬í¼Æ
=SUM(FREQUENCY(MOD(A2+(ROW(INDIRECT("1:"&TEXT(B2-A2,"[m]")))-1)/1440,1),G$2:H$3+(C2="Yes"))*{1;0;1;0;1})
1

µû¤À¤H¼Æ

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

TOP

¦^´_ 5# ML089

ÁÂÁÂML089¦Ñ®vªºÀ°¦£¸ÑÃD¡A¦¹¨ç¼Æ¯uªº­n¦n¦n¦¬ÂøѪR¡AÁÂÁ¦Ѯv¡A¯¬¦Ñ®v:·s¦~§Ö¼Ö.¨­Åé°·±d!

TOP

        ÀR«ä¦Û¦b : ¦³®É·í«äµL®É­W¡A¦n¤Ñ­n¿n«B¨Ó³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD