Hi,
Following help from other members on here, I'm finally getting somewhere!
I now have a table like this:-
20/10/2008 Boris Clocked In 07:15
20/10/2008 Boris Clocked Out 10:15
20/10/2008 Boris Clocked In 11:15
20/10/2008 Boris Clocked Out 16:30
20/10/2008 Ben Clocked In 07:15
20/10/2008 Ben Clocked Out 10:15
20/10/2008 Ben Clocked In 11:15
20/10/2008 Ben Clocked Out 16:30
20/10/2008 Bill Clocked In 07:15
20/10/2008 Bill Clocked Out 18:00
I need to calculate the total hours each employee is clocked in for each day.
The problem have is that each person can clock in and out a different number of times - i.e. if they clock out to go to the doctor's and then clock back in when they get back.
Does anyone have any ideas how to build a query to do this?
Many thanks
Matthew
Following help from other members on here, I'm finally getting somewhere!
I now have a table like this:-
20/10/2008 Boris Clocked In 07:15
20/10/2008 Boris Clocked Out 10:15
20/10/2008 Boris Clocked In 11:15
20/10/2008 Boris Clocked Out 16:30
20/10/2008 Ben Clocked In 07:15
20/10/2008 Ben Clocked Out 10:15
20/10/2008 Ben Clocked In 11:15
20/10/2008 Ben Clocked Out 16:30
20/10/2008 Bill Clocked In 07:15
20/10/2008 Bill Clocked Out 18:00
I need to calculate the total hours each employee is clocked in for each day.
The problem have is that each person can clock in and out a different number of times - i.e. if they clock out to go to the doctor's and then clock back in when they get back.
Does anyone have any ideas how to build a query to do this?
Many thanks
Matthew