Link to home
Start Free TrialLog in
Avatar of Hiroyuki Tamura
Hiroyuki TamuraFlag for United States of America

asked on

Calculate Number of Employees Who Were At Work Each Hour?

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.
Avatar of Hamed Nasr
Hamed Nasr
Flag of Oman image

Upload a sample table with few representative records.
Show the required output.
ASKER CERTIFIED SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Hiroyuki Tamura

ASKER

Thank you!
I'll try and let you now.
Works great!
Glad you were able to understand the directions.  This isn't a trivial task.