Why is my COUNTIF formula returning “0”? - Apple Community
So when you use =TIME(15,20,0) it seems that your result should be just 3:20 PM and you should be able to compare to the 3:20 PM in your Employee Count table. The problem is that that each of the cells has an