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