Countif time is between two nominated times

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of clients and the time they were seen. I need to count how
many clients where seen between set time eg how many were seen between
12:00:00am adn 04:00:00am

Please help
 
I assume you mean between 12 (midday) and 4 (pm):

=SUMPRODUCT(--($A$1:$A$20>=(12/24)),--($A$1:$A$20<=(16/24)))

If you mean between 12 (midnight) and 4 (am) ! then

=SUMPRODUCT(--($A$1:$A$20<=(4/24)))

HTH
 
Thanks for your guidance Toppers, it seems to have worked. As I need to now
calculate the number of clients that come with each 4 hr block over 24 hour
period that is how many between 12mn -4am, 4am -8am, 8am-12md, 12md-4pm,
4pm-8pm and 8pm-12mn. Can I just substitute the times into the formula?

I did try it and it seemed to miss a couple in each time slot
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating the number of entries between 2 times 2
Check if Time falls between ? 2
Countifs with different restrictions 1
Convert times to text string 3
Difference between times. Start time: 11:30PM End time: 5 AM 5
Need formula for time between two events 5
countif where condition should be met 3
Sum based upon matching data in different columns 1

Back
Top