COUNTIF(Time greater than 1 minute)

[want to learn]

I have a column with h:mm:ss. I want to count all the cells that are greater than 0:01:00. Any ideas?
Thanks.

 

[kieran]

This works for me for the range a1:a10.

=COUNTIF(A1:A10,">0:1:00")

 

[Nogslaw]

=COUNTIF(A1:A10,">0:01:00")

or

=COUNTIF(A1:A9,">" & 1/(24*60))

Remember that to the computer 1 = 1 day, so 1day/24hours per day*3600seconds per hour = 1 second

**Post Edited to be correct

 

[Scott Huish]

If you're going to use a fraction, I believe you want:
=COUNTIF(A:A,">"&1/1440)

 

[Nogslaw]

My apologies, I read your time measurement incorrectly earlier. I thought it said > 1second, it actually says >1minute.

Hotpepper is correct with his formulas

 

[want to learn]

Thanks to all,
I thought I had tried that but I guess not.