é¦å
ï¼ç¡®ä¿ B åçæ ¼å¼æ¯æ¶é´åï¼
ç¶åå¢å C åãD åï¼è®¾ç½®æ常è§åï¼
å¨ C1 åå
æ ¼è¾å
¥ä»¥ä¸å
¬å¼ï¼å¯ä»¥ç´æ¥æä¸é¢å
¬å¼å¤å¶ç²è´´å° C1ï¼ï¼
=TEXT(TIMEVALUE("0:15:00")*(ROW()-1),"hh:mm:ss") & "-" & TEXT(TIMEVALUE("0:15:00")*ROW(),"hh:mm:ss")
ç¶åä¸æå° 96 è¡ã
å¨ D1 åå
æ ¼è¾å
¥ä»¥ä¸å
¬å¼ï¼
=COUNTIF(A:A,"<" & TEXT(TIMEVALUE("0:15:00")*ROW(),"hh:mm:ss"))-COUNTIF(A:A, "<" & TEXT(TIMEVALUE("0:15:00")*(ROW()-1),"hh:mm:ss"))
ç¶åä¸æå° 96 è¡ãä¹è®¸ç¬¬ 96 è¡éè¦ä½ä¿®æ¹ãèªå·±å®æå§
追é®![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4bed2e738bd4b31c864ea2ed89d6277f9e2ff871?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
é¢ï¼ç»æé½æ¯0.ã
追çå¦å¿äºä½ çæ¶é´å¨ B åã
æ D1 å
¬å¼éç Aï¼A æ¹ä¸º Bï¼B(两个å°æ¹)ï¼ç¶åä¸æ 96 è¡ã
追é®![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8b82b9014a90f603bd7b80113712b31bb151ed99?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
è¿ããè¿æ¯0.ã