# Counting the number of weekdays and times with in those days

#### rcdiago

##### New Member
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.

Robert

 Date/ Time In

<tbody>
</tbody>
 Date/ Time Out

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

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

<tbody>
</tbody>
7 am
Monday6
 5/12/2014 10:15

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

<tbody>
</tbody>
8 am
Tuesday7
 7/12/2014 10:10

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

<tbody>
</tbody>
9 am
Wednesday0
 7/14/2014 8:10

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

<tbody>
</tbody>
10 am
Thursday5
 7/17/2014 14:30

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

<tbody>
</tbody>
11 am
Friday2
 8/5/2014 8:25

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

<tbody>
</tbody>
12 pm
Saturday1
 8/5/2014 8:30

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

<tbody>
</tbody>
1 pm
Total22
 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>

### Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Replies
3
Views
762
Replies
6
Views
608
Replies
6
Views
754
Replies
3
Views
294
Replies
8
Views
754

1,195,992
Messages
6,012,741
Members
441,724
Latest member
Aalbid

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back