Calculating time

[Fyrdawg]

Hi All.
I have a spreadsheet with times on it and I am trying to get it to determine how many times are less than or equal to 7 min. Attached is a simple version of my spreadsheet. I was working with the following formula but I can seem to figure out the last bit of it to determine less then/equal to: couniif (A1:A5, 0:07:00)

Any help is greatly appreciated.

0:09:57

0:01:22

0:06:56

0:07:45

0:03:19

<tbody>
</tbody>

 

[Weazel]

maybe...

couniif (A1:A5, "<=0:07:00")

 

[Fyrdawg]

So if figured got this formula to work: =COUNTIF(M3:M437,"<= 0:07:00"), but I can't get it to compute =COUNTIF(M3:M437,">0:07:00").

 

[Weazel]

its hard to say because its working for me....

you could try something like....

=SUMPRODUCT(--(M3:M437>"0:7:00"+0))

 

[Fyrdawg]

Thank you for your help on this.

That formula worked, but it's counting any blank spaces I have also. When I change the range to just the populated cells, it's computing the number accurately. I know there is a way to tell the formula to ignore any blank spaces?

 

[Weazel]

maybe...

=SUMPRODUCT((M3:M437>"0:7:00"+0)*(M3:M437<>""))

 

[Fyrdawg]

Boom.. That worked... Thank you, thank you, thank you...