I have a large spreadsheet I use to analyze data. Currently I’m stuck trying to get it to count values of a column that have time values between two values. The column has data of time ranging from 0 hours to several hours and minutes:
In the example above, I’d like to count the cells with values >2 hours and less than 3 hours.
I’ve made the formula work in all other instances until I try it on time:
=DCOUNTA(Raw_Data,’Data Entry’!$Q$2,DO8:DR9). It doesn;t seem to work when these criteria are entered:
By: Dave Blomquist