How to determine # of employees who worked during a time interval

[Dan13]

Hi. My goal is to create a database where I can extract the number of employees who have worked during each one hour interval in a 24 hr day (00:00 - 1:00, 1:00 - 2:00,...11:00 - 11:59).

tEmployees contains the employees Punch in & outs for a given month. My problem is tracking the overnight employees working PM > AM. My whole design might be wrong, I'll take any feedback/design tips. Thanks

[NeoPa]

It's hard to comment on a design when you don't share it Dan ;-)

[mythjen]

At least we could know what you're using. Let's see it Dan.

[ariful alam]

if your database table has fields like below:

emp_name, emp_time_of_wor k, details

you have to make an query that takes parameter for emp_time_of_wor k like "between [full date/time format of now] and [full date/time format of now - 1]"
and you can run it in 1 hour tread to execute the query.