I am trying to get number of employees per hour using their start and stop times.
I can do this in excel using
=(COUNTIF($F$2:$F$42,">"&A2)-COUNTIF($E$2:$E$42,">"&A2))
In a table like
Time |
# per hr |
|
Start |
Stop |
|
4 |
|
|
800 |
1 |
4 |
|
|
800 |
200 |
4 |
|
|
800 |
300 |
4 |
|
|
800 |
400 |
4 |
|
600 |
800 |
500 |
4 |
|
600 |
800 |
600 |
6 |
|
800 |
1600 |
700 |
6 |
|
800 |
1400 |
800 |
13 |
|
800 |
1600 |
900 |
14 |
|
800 |
1600 |
ect ect ..
I need to do this same thing in Access ....I have been searching for anyway and am coming up blank
Table with Start and End times in the table unlike the excel example above in the table the start and end times are all 4 digits no "zero's" are dropped in the times in case that matters (eg 0000, 0100, 0200, 0300 ect)
Any help with VBA or any other method that will return number of employees on duty each hour
Thank you,