I have inherited this DB that has many tables etc. One of the functions I
need to do is figure out how much time a person has worked in a month from a
table.
The fields are date, ClockIn, Break1Out, Break1In, LunchOut, LunchIn,
Break2Out, Break2In, ClockOut, Break3In, Break3Out.
What I am looking to do is take the total time from clockIn to ClockOut and
subtract the breaks and lunch time. I need this by Person for ? period of
time and combine in together to = 1 number for the month.
Any help would be appreciated.

On Tue, 5 Jan 2010 13:49:01 -0800, LG <(E-Mail Removed)> wrote:

>I have inherited this DB that has many tables etc. One of the functions I
>need to do is figure out how much time a person has worked in a month from a
>table.
>The fields are date, ClockIn, Break1Out, Break1In, LunchOut, LunchIn,
>Break2Out, Break2In, ClockOut, Break3In, Break3Out.
>What I am looking to do is take the total time from clockIn to ClockOut and
>subtract the breaks and lunch time. I need this by Person for ? period of
>time and combine in together to = 1 number for the month.
>Any help would be appreciated.

You'll need a Query using the DateDiff() function to calculate the length of
each work period. Type Ctrl-G to open the VBA editor and press F1 to get help;
look at the Help message for DateDiff.

This may be a bit more complex if some of the fields are NULL (i.e. the person
didn't take Break2, or (worse) forgot to clock in or clock out).
--

John W. Vinson [MVP]