Originally Posted by
NBVC
It has to do with precision when manipulating multiple decimal numbers like time. You are using formula in D4 like =E3+TIME(0,$F$1,0) copied down... that causes inaccuracies when comparing to fixed entry time
What I would do is insert a new column between column B and C, then in C3 enter formula:
=ROUND(B3,6)
copied down
in the new G2, enter:
=COUNTIFS($C:$C,">="&ROUND($E3,6),$C:$C,"<="&ROUND($F3,6),$A:$A,G$1)
copied down. The sum should now be 554. Copy across. I used the Round() function to "control" the result to 6 decimals
Bookmarks