We help IT Professionals succeed at work.

Calculate Number of Employees Who Were At Work Each Hour?

Hiroyuki Tamura
on
132 Views
Last Modified: 2018-10-15
Calculate Number of Employees Who Were At Work Each Hour on MS Access?

I am trying to come up with a set of formulas to calculate how many employees were on the clock fo each hour of the day based on:

https://www.mrexcel.com/forum/excel-questions/614617-calculate-number-employees-who-were-work-each-hour.html

The link provide the solution for MS Excel but I would like to build with MS Access.
Comment
Watch Question

Hamed NasrRetired IT Professional
CERTIFIED EXPERT

Commented:
Upload a sample table with few representative records.
Show the required output.
CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Hiroyuki TamuraField Engineer

Author

Commented:
Thank you!
I'll try and let you now.
Hiroyuki TamuraField Engineer

Author

Commented:
Works great!
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
Glad you were able to understand the directions.  This isn't a trivial task.