Count a certain # of interaction on a timeline.

[xatomicx]

Hi everyone, i'm building a chart, in this chart i need to calculate a certain number of interaction based on time.

Example...
i have sheet ranging from sheet1 to sheet4,
On each sheet, we set a drop down menu with a timestamp of the interaction with format " mm/dd \/ hh:mm ".

i want to know, the number of timestamps between certains hours at certain date.

How do i do a formula that will count on all my sheet, all timestamp between 8:00 AM to 8:30 AM on april 4th?

i'm having issue figuring out how to set a "in between" countif, respecting date and hours.

If anyone can help me build a formula for my example of 8-8:30, i will be able to adapt it to all other hours of the day.

Thanks!

[Paul]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.