Formula for number of entries in colum that are greater than 2 hr

N

Nancy L

I'm fairly new to excel and need a formula that will tell me the number of
time entries in a very long column that are greater than 2 hours. Using Excel
2003
 
D

Dave Peterson

=countif(a:a,">"&time(2,0,0))





Nancy said:
I'm fairly new to excel and need a formula that will tell me the number of
time entries in a very long column that are greater than 2 hours. Using Excel
2003
Click to expand...
 

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

Work Budget Salary vs Real Time Salary 0
Computing Elapsed Time 4
how can I get the total hrs of a delay when it is greater than 24 2
How can the font and size of (all) citation numbers be altered? 1
Greater than, less than, AS WELL AS value=0 5
Average Function but exclude info 4
Copy previous record into form field 0
Vlookup display value if greater than a number 0

Top