Question on the countif function and times

M

MTSkibum

I need to count all the times between 12:01 am and 12:10 am in a collumn, i
have been messing around with variations of the formula, i have even tried to
use cells to hold 12:01 and 12:10, but that didnt work either.

=COUNTIF(G1:G500,">12:01")-COUNTIF(G1:G238,">12:10")
with this equation i get a 0 value


=COUNTIF(G1:G500,">12:01")-COUNTIF(G1:G238,"<12:10")
with this formula i get an answer of -238, ie the negative value of the
number of total entries

thanks for any help
 
M

MTSkibum

they were the same, i was using 1-500, but right before i copied and pasted i
tried to change it to 238 to make it match the text i typed in.

In the file they are the same, and it reads 1-500, although there are only
238 entries.
 
B

Bob Phillips

I think your first formula is correct and you may be getting a good answer,
bt it is being formatted as time.

Try this, in a completely new cell

=N(COUNTIF(G1:G500,">12:01")-COUNTIF(G1:G500,">12:10"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the weighted average of text that have been given values 1
Count entries in the column translating to minutes. 5
possible countif formula? 3
CountIf on Date / Time 14
Combining Functions (Sumproduct and Countif) 5
How to store the calculated value into the original cell? 1
Countif between a range? 1
Time Countif help or convert to text 3

Top