Each month the user has to count the number of service tickets that have arrived between certain time ranges. They want to gauge during what times we seem to get the biggest batch of service requests.
6 am to 10 am
10 am to 5 pm
5 pm to 6 pm
6 pm to 6 am
The format of the cells are:
The formula the user has tried for 10 am to 5 pm is:
It gives a result of 676, and the user knows from manually counting that there is only 327 cells that have a time between 10 am and 5 pm.
The times are actually dates and times, so the values aren't 1:21:19 AM but 9/14/2006 1:21:19 AM.
Modifying the formula to
The "INT(MIN())" giving you the value of the particular day...
Obtained from the OzGrid Help Forum.
Solution provided by Mark Wyde.
|How to use VBA script to count files/subfolders using a range from WB for the root folder|
|How to VBA code to count duplicates FAST|
|How to set a countdown timer to beep under 10 seconds|
|How to count the number of cells containing a comment that contains the word LATE|