Counting if two ranges occur between two times

Hi all,

I have two columns, one which contains the start time of a shift and the second contains the end time. I need to count if the start/end times fall within set timescales.

Column A.....Column B
0830............1800
0845............1645
0830............1700
0900............1730
0830............1700

Between 0830-0845 would be 3
Between 0830-0900 would be 4

I've tried a number of countifs, countif(and and sumproduct and it's just not returning the right result.

Any help would be very much appreciated.

Originally Posted by elleb

Between 0830-0845 would be 3
Between 0830-0900 would be 4

Is this 0830 or 0845?

Hi,

It could be either, it was just giving an example of counting between different set time ranges. But, for what I want yes it would go up in 15minute segments.