How do I count a range of times and link it another worksheet.

[Jay C]

How do I count a range of times and link it to another worksheet. For
example I am trying to count all the start times between 6:00am and 6:59am on
Monday for example and link the total to a summary page. I want to set it up
so that I can count from 7:00 to 7:59 and so forth. I have tried to use a
count / countif and do not a solver installed so I can not use Sumproduct.

Any help is greatly apprecitated.

 

[Eduardo]

Hi Jay,
you don't need solver to use sumproduct please provide an example, thanks

 

[Luke M]

Could do something like this:
=COUNTIF(A2:A10,">="&TIMEVALUE("6:00
AM"))-COUNTIF(A2:A10,">"&TIMEVALUE("6:59 AM"))

Note that you could replace the TIMEVALUE function with a cell reference, if
you have cells somewhere that already have your limiting values. Say, B1 =
6:00 am, C1 = 7:00 am. New function is:

=COUNTIF(A2:A10,">="&B1)-COUNTIF(A2:A10,">="&C1)

 

[Luke M]

Could do something like this:
=COUNTIF(A2:A10,">="&TIMEVALUE("6:00
AM"))-COUNTIF(A2:A10,">"&TIMEVALUE("6:59 AM"))

Note that you could replace the TIMEVALUE function with a cell reference, if
you have cells somewhere that already have your limiting values. Say, B1 =
6:00 am, C1 = 7:00 am. New function is:

=COUNTIF(A2:A10,">="&B1)-COUNTIF(A2:A10,">="&C1)