Please can someone help to come up with formula that would count cells with text if condition is "time"? The "count" column is where the formula that would count the number of fruits once the "start and end" time were met. Example: the first count in "count" column is 2 - this is because "apple and pears" are with in 5:00 AM and 5:59 AM.[TABLE="width: 500"]
<tbody>[TR]
[TD]Time[/TD]
[TD]Fruits[/TD]
[TD][/TD]
[TD]Start[/TD]
[TD]End[/TD]
[TD]Count[/TD]
[TD]Explanation[/TD]
[/TR]
[TR]
[TD]5:30 AM[/TD]
[TD]Apple[/TD]
[TD][/TD]
[TD]5:00 AM[/TD]
[TD]5:59 AM[/TD]
[TD]2[/TD]
[TD]Apple & Pears[/TD]
[/TR]
[TR]
[TD]6:35 AM[/TD]
[TD]Banana[/TD]
[TD][/TD]
[TD]6:00 AM[/TD]
[TD]6:59 AM[/TD]
[TD]1[/TD]
[TD]Banana[/TD]
[/TR]
[TR]
[TD]7:20 AM[/TD]
[TD]Orange[/TD]
[TD][/TD]
[TD]7:00 AM[/TD]
[TD]7:59 AM[/TD]
[TD]1[/TD]
[TD]Orange[/TD]
[/TR]
[TR]
[TD]9:02 AM[/TD]
[TD]Apple[/TD]
[TD][/TD]
[TD]8:OO AM[/TD]
[TD]8:59 AM[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10: 56 AM[/TD]
[TD]Kiwi[/TD]
[TD][/TD]
[TD]9:00 AM[/TD]
[TD]9:59 AM[/TD]
[TD]1[/TD]
[TD]Apple[/TD]
[/TR]
[TR]
[TD]5: 40 AM[/TD]
[TD]Pears[/TD]
[TD][/TD]
[TD]10: AM[/TD]
[TD]10:59 AM[/TD]
[TD]1[/TD]
[TD]Kiwi[/TD]
[/TR]
</tbody>[/TABLE]
<tbody>[TR]
[TD]Time[/TD]
[TD]Fruits[/TD]
[TD][/TD]
[TD]Start[/TD]
[TD]End[/TD]
[TD]Count[/TD]
[TD]Explanation[/TD]
[/TR]
[TR]
[TD]5:30 AM[/TD]
[TD]Apple[/TD]
[TD][/TD]
[TD]5:00 AM[/TD]
[TD]5:59 AM[/TD]
[TD]2[/TD]
[TD]Apple & Pears[/TD]
[/TR]
[TR]
[TD]6:35 AM[/TD]
[TD]Banana[/TD]
[TD][/TD]
[TD]6:00 AM[/TD]
[TD]6:59 AM[/TD]
[TD]1[/TD]
[TD]Banana[/TD]
[/TR]
[TR]
[TD]7:20 AM[/TD]
[TD]Orange[/TD]
[TD][/TD]
[TD]7:00 AM[/TD]
[TD]7:59 AM[/TD]
[TD]1[/TD]
[TD]Orange[/TD]
[/TR]
[TR]
[TD]9:02 AM[/TD]
[TD]Apple[/TD]
[TD][/TD]
[TD]8:OO AM[/TD]
[TD]8:59 AM[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10: 56 AM[/TD]
[TD]Kiwi[/TD]
[TD][/TD]
[TD]9:00 AM[/TD]
[TD]9:59 AM[/TD]
[TD]1[/TD]
[TD]Apple[/TD]
[/TR]
[TR]
[TD]5: 40 AM[/TD]
[TD]Pears[/TD]
[TD][/TD]
[TD]10: AM[/TD]
[TD]10:59 AM[/TD]
[TD]1[/TD]
[TD]Kiwi[/TD]
[/TR]
</tbody>[/TABLE]