Countif to Count Activities in a time interval on a Specific Date

Thanks marvin, however the formula way that Ron shared works best for me.
Cheers !!

Originally Posted by MarvinP

I'd create a new column that rounds the minutes to a half hour and use it in my Pivot Table.
Look at http://www.excelforum.com/excel-gene...half-hour.html or
http://www.fanhow.com/knowhow:Round_...Excel_34292849