Employee per hour

[Rivmage]

Hi all,

I'm using Access 2007 to track the time of employees in a project. I have a start time and an end in a project. Now I need to find out how many employees were in a project in hour intervals. Example: Employee A has a start time of 06:14 and an end time of 14:05.

So, I need the database to look at that window and mark.

Employee A was active for the time frames of
0600 to 0659
0700 to 0759
0800 to 0859
0900 to 0959
1000 to 1059
1100 to 1159
1200 to 1259
1300 to 1359
1400 to 1459

Thanks in advance for any help.
Please let me know if I need to give another example or clear anything up.

Scott

[Allan Murphy]

Are there different start and finish times for the employees?

Employee A has a start time of 06:14 and an end time of 14:05

You will have to make some business rules regarding the start and finish times. In the above example starting at 06:14 the employee would be counted in 0600 to 0659. Now, finishing at 14:05 I believe the employee should be counted in the 1300 to 1359 interval and not the 1400 to 1459 interval as the employee is not there for most of the interval.

At what time in the hour interval do you count the employee e.g. If I started at 06:45 would I be counted in the 0600 to 0659 interval as I was there for only 15 minutes? The same will apply to my end time.

Please post some sample data in Access 2003 format if possible.