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.
<tbody>
</tbody>
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>