How to calculate how many rows meet a time check criteria

[Mark McInerney]

Hi All,

I have a two columns of data in column b and c. Column B holds a start time and Column C holds a finish time.

I need a formula in Cell E1 that can count the number of rows where a time that I insert in D1 is between the start time and finish times that are listed in Column B and C?

Any help appreciated.

Thanks.

 

[jtakw]

Hi,

Does this help:

Excel 2010
	B	C	D	E
1	8:00 AM	12:00 PM	10:30 AM	2
2	11:00 AM	2:00 PM
3	10:00 AM	11:30 AM
Sheet26

Cell Formulas
Range	Formula
E1	=COUNTIFS(B1:B3,"<="&D1,C1:C3,">="&D1)

 

[Mark McInerney]

Out of the Park!! Thank You for taking the time to review. Works a treat!

 

[jtakw]

You're welcome, glad it worked for you.