I am trying to counif and create a cumilative flow over headcount based on the day. Sample is below:
Trying to show how many employees are working at any given moment as such: I dont want to double count but just show x amount of people are work between these times
Trying to show how many employees are working at any given moment as such: I dont want to double count but just show x amount of people are work between these times
1/17/22 | ||
5:00:00 AM | 5:59:59 AM | |
6:00:00 AM | 6:59:59 AM | |
7:00:00 AM | 7:59:59 AM | |
8:00:00 AM | 8:59:59 AM | |
9:00:00 AM | 9:59:59 AM | |
10:00:00 AM | 10:59:59 AM | |
11:00:00 AM | 11:59:59 AM | |
12:00:00 PM | 12:59:59 PM | |
1:00:00 PM | 1:59:59 PM | |
2:00:00 PM | 2:59:59 PM | |
3:00:00 PM | 3:59:59 PM | |
4:00:00 PM | 4:59:59 PM | |
5:00:00 PM | 5:59:59 PM | |
6:00:00 PM | 6:59:59 PM | |
7:00:00 PM | 7:59:59 PM | |
8:00:00 PM | 8:59:59 PM | |
9:00:00 PM | 9:59:59 PM | |
10:00:00 PM | 10:59:59 PM | |
11:00:00 PM | 11:59:59 PM | |
12:00:00 AM | 12:59:59 AM |
1/17/22 | 5:00:00 AM | 1:19:00 PM |
1/17/22 | 7:00:00 AM | 4:00:00 PM |
1/17/22 | 7:00:00 AM | 8:01:00 PM |
1/17/22 | 8:00:00 AM | 10:08:00 PM |
1/17/22 | 8:00:00 AM | 10:02:00 AM |
1/17/22 | 8:00:00 AM | 10:00:00 AM |
1/17/22 | 8:00:00 AM | 10:39:00 PM |
1/17/22 | 8:00:00 AM | 9:36:00 AM |
1/17/22 | 8:00:00 AM | 8:49:00 AM |
1/17/22 | 8:00:00 AM | 4:57:00 PM |
1/17/22 | 8:00:00 AM | 8:48:00 PM |
1/17/22 | 8:00:00 AM | 8:47:00 PM |
1/17/22 | 8:00:00 AM | 8:46:00 PM |
1/17/22 | 8:00:00 AM | 2:05:00 PM |
1/17/22 | 8:00:00 AM | 8:39:00 PM |
1/17/22 | 10:00:00 AM | 4:07:00 PM |
1/17/22 | 10:00:00 AM | 4:34:00 PM |
1/17/22 | 10:00:00 AM | 8:53:00 PM |
1/17/22 | 10:00:00 AM | 8:48:00 PM |
1/17/22 | 10:00:00 AM | 5:27:00 PM |
1/17/22 | 10:00:00 AM | 10:12:00 PM |
1/17/22 | 10:00:00 AM | 8:53:00 PM |
1/17/22 | 10:00:00 AM | 8:14:00 PM |
1/17/22 | 10:00:00 AM | 8:39:00 PM |
1/17/22 | 10:00:00 AM | 3:57:00 PM |
1/17/22 | 10:00:00 AM | 8:53:00 PM |
1/17/22 | 10:00:00 AM | 7:51:00 PM |
1/17/22 | 10:00:00 AM | 8:49:00 PM |
1/17/22 | 10:00:00 AM | 7:55:00 PM |
1/17/22 | 10:00:00 AM | 5:47:00 PM |
1/17/22 | 10:00:00 AM | 9:31:00 PM |
1/17/22 | 10:00:00 AM | 3:55:00 PM |
1/17/22 | 10:00:00 AM | 10:50:00 PM |
1/17/22 | 10:00:00 AM | 9:56:00 PM |
1/17/22 | 10:00:00 AM | 10:09:00 PM |
1/17/22 | 10:00:00 AM | 11:11:00 PM |
1/17/22 | 10:00:00 AM | 9:57:00 PM |
1/17/22 | 10:15:00 AM | 3:10:00 PM |
1/17/22 | 11:00:00 AM | 3:41:00 PM |
1/17/22 | 11:00:00 AM | 11:39:00 PM |
1/17/22 | 11:00:00 AM | 4:57:00 PM |
1/17/22 | 11:00:00 AM | 9:01:00 PM |
1/17/22 | 11:00:00 AM | 3:57:00 PM |
1/17/22 | 11:00:00 AM | 10:48:00 PM |
1/17/22 | 11:00:00 AM | 9:56:00 PM |
1/17/22 | 11:00:00 AM | 10:47:00 PM |
1/17/22 | 11:00:00 AM | 4:41:00 PM |
1/17/22 | 12:00:00 PM | 7:53:00 PM |
