# Calculating time

#### Fyrdawg

##### New Member
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>

### Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

#### Weazel

##### Well-known Member
maybe...

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

#### Fyrdawg

##### New Member
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

##### Well-known Member
its hard to say because its working for me....

you could try something like....

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

#### Fyrdawg

##### New Member
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

##### Well-known Member
maybe...

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

#### Fyrdawg

##### New Member
Boom.. That worked... Thank you, thank you, thank you...

Replies
13
Views
765
Replies
1
Views
505
Replies
6
Views
731
Replies
15
Views
444
Replies
3
Views
619

Threads
1,191,133
Messages
5,984,859
Members
439,921
Latest member
Neocold

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back