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:

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.
Avatar of PatHartman
Flag of United States of America image

Link to home
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


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.