ExcelBanter - SUMIF function question

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SUMIF function question (https://www.excelbanter.com/excel-worksheet-functions/54398-sumif-function-question.html)

SUMIF function question

Hi guys,

I am trying to count the instances between 15 minutes periods.

For example my data is:

12:05:34
12:11:45
12:12:12
12:14:43
12:15:59

I want my function to calculate how many instances there are between
12:00:00 am and 12:15:00 am. (for the above data it would be 4).

Can anyone help me?

Thanks!

khux

SUMIF function question

Let's assume your data is stored in cells A1:A5.

=COUNTIF(A1:A5,"=12:00:00")-COUNTIF(A1:A5,"12:15:00")

This calculation may change the format of the cell to display time, so in
that case you'd need to change the format back to General (or whatever you
need).

HTH,
Elkar

"khux" wrote:

Hi guys,

I am trying to count the instances between 15 minutes periods.

For example my data is:

12:05:34
12:11:45
12:12:12
12:14:43
12:15:59

I want my function to calculate how many instances there are between
12:00:00 am and 12:15:00 am. (for the above data it would be 4).

Can anyone help me?

Thanks!

khux