Check to See Client Count during Every Hour

Hi everyone,

I am trying to write a formula that will show how many clients are in a building every hour from 6am to 6pm. I have a table with Time In and Time Out columns for each client. There is another table with a list of times on the hour from 6am to 6pm. I tried the following formula to count the number of clients, but it always returns a zero:

Please Login or Register  to view this content.

Any help is appreciated. I attached the spreadsheet in question to this post for clarification. Thank you!

Try this formula in cell V3 and copy it down to V15

Formula:

Please Login or Register  to view this content.

Originally Posted by Crystalyzer

Try this formula in cell V3 and copy it down to V15

Formula:

Please Login or Register  to view this content.

Wow, that one little change make this formula work perfectly. Thank you so much for your help!