Counting the number of weekdays and times with in those days

[rcdiago]

Hello, Please help! I believe I figured out how to obtain the number of entries for the day of the week =SUMPRODUCT(--(WEEKDAY(C$2:C$23)=1)) for Sunday and so on....

I also need to know how many entries occur during that weekday at a certain time. For example from the data I need to know how many entries occurred on a Monday at 9 am.

Below is sample data due to privacy.

Thanks in advance.

Robert

Date/ Time In <tbody> </tbody>

Date/ Time Out <tbody> </tbody>

Sunday

Monday

Tuesday

Wednesday

Thursday

Friday

Saturday

Sunday

1

3/20/2014 13:45 <tbody> </tbody>

3/20/2014 14:25 <tbody> </tbody>

7 am

Monday

6

5/12/2014 10:15 <tbody> </tbody>

5/12/2014 10:35 <tbody> </tbody>

8 am

Tuesday

7

7/12/2014 10:10 <tbody> </tbody>

7/12/2014 10:45 <tbody> </tbody>

9 am

Wednesday

0

7/14/2014 8:10 <tbody> </tbody>

7/14/2014 8:25 <tbody> </tbody>

10 am

Thursday

5

7/17/2014 14:30 <tbody> </tbody>

7/17/2014 14:55 <tbody> </tbody>

11 am

Friday

2

8/5/2014 8:25 <tbody> </tbody>

8/5/2014 8:30 <tbody> </tbody>

12 pm

Saturday

1

8/5/2014 8:30 <tbody> </tbody>

8/5/2014 8:35 <tbody> </tbody>

1 pm

Total

22

9/4/2014 13:30 <tbody> </tbody>

9/4/2014 14:20 <tbody> </tbody>

2 pm

9/15/2014 9:45 <tbody> </tbody>

9/15/2014 11:00 <tbody> </tbody>

3 pm

9/16/2014 9:20 <tbody> </tbody>

9/16/2014 9:30 <tbody> </tbody>

4 pm

9/22/2014 12:00 <tbody> </tbody>

9/22/2014 12:05 <tbody> </tbody>

5 pm

10/19/2014 12:35 <tbody> </tbody>

10/19/2014 12:40 <tbody> </tbody>

6 pm

10/27/2014 10:45 <tbody> </tbody>

10/27/2014 11:00 <tbody> </tbody>

7 pm

10/30/2014 14:40 <tbody> </tbody>

10/30/2014 15:05 <tbody> </tbody>

8 pm

11/3/2014 11:15 <tbody> </tbody>

11/3/2014 11:25 <tbody> </tbody>

9 pm

11/10/2014 9:55 <tbody> </tbody>

11/10/2014 10:10 <tbody> </tbody>

10 pm

11/13/2014 13:10 <tbody> </tbody>

11/13/2014 13:20 <tbody> </tbody>

11 pm

11/14/2014 14:00 <tbody> </tbody>

11/14/2014 14:35 <tbody> </tbody>

11/18/2014 9:45 <tbody> </tbody>

11/18/2014 9:55 <tbody> </tbody>

11/21/2014 13:50 <tbody> </tbody>

11/21/2014 14:15 <tbody> </tbody>

12/8/2014 9:45 <tbody> </tbody>

12/8/2014 10:55 <tbody> </tbody>

12/15/2014 13:45 <tbody> </tbody>

12/15/2014 14:55 <tbody> </tbody>

<tbody>
</tbody>