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
<tbody>
</tbody>
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
<tbody> </tbody> |
<tbody> </tbody> | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | ||||||
Sunday | 1 |
<tbody> </tbody> |
<tbody> </tbody> | 7 am | ||||||||||
Monday | 6 |
<tbody> </tbody> |
<tbody> </tbody> | 8 am | ||||||||||
Tuesday | 7 |
<tbody> </tbody> |
<tbody> </tbody> | 9 am | ||||||||||
Wednesday | 0 |
<tbody> </tbody> |
<tbody> </tbody> | 10 am | ||||||||||
Thursday | 5 |
<tbody> </tbody> |
<tbody> </tbody> | 11 am | ||||||||||
Friday | 2 |
<tbody> </tbody> |
<tbody> </tbody> | 12 pm | ||||||||||
Saturday | 1 |
<tbody> </tbody> |
<tbody> </tbody> | 1 pm | ||||||||||
Total | 22 |
<tbody> </tbody> |
<tbody> </tbody> | 2 pm | ||||||||||
<tbody> </tbody> |
<tbody> </tbody> | 3 pm | ||||||||||||
<tbody> </tbody> |
<tbody> </tbody> | 4 pm | ||||||||||||
<tbody> </tbody> |
<tbody> </tbody> | 5 pm | ||||||||||||
<tbody> </tbody> |
<tbody> </tbody> | 6 pm | ||||||||||||
<tbody> </tbody> |
<tbody> </tbody> | 7 pm | ||||||||||||
<tbody> </tbody> |
<tbody> </tbody> | 8 pm | ||||||||||||
<tbody> </tbody> |
<tbody> </tbody> | 9 pm | ||||||||||||
<tbody> </tbody> |
<tbody> </tbody> | 10 pm | ||||||||||||
<tbody> </tbody> |
<tbody> </tbody> | 11 pm | ||||||||||||
<tbody> </tbody> |
<tbody> </tbody> | |||||||||||||
<tbody> </tbody> |
<tbody> </tbody> | |||||||||||||
<tbody> </tbody> |
<tbody> </tbody> | |||||||||||||
<tbody> </tbody> |
<tbody> </tbody> | |||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>