Using dcounta function on time values

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:

0:00
0:33
2:41
3:12

 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:

Elapsed Elapsed
>1.99 <3

Suggestions?

By: Dave Blomquist

Leave a Reply

Your email address will not be published. Required fields are marked *