schedule workers time with break and lunch

[doc6]

I am having a problem in trying to figure out how to add break and lunch times to a schedule that I created. I have workers that need to produce many different items within that persons work day. each item has it's own record. I can produce the scheduled times for completion for each item. But I need to add a varying Break and Lunch time in the schedule. I am not sure of how to accomplish this. I am trying to add the break and lunch records to a table and then re-calculate the times for each item to be completed after the breaks and lunch. I create the table that holds the run rate of each item and then produce the resulting times due thru a report that calculates the time due in a running sum. Would appreciate any advise you can give me.

 

[DougP]

Well try making a unique field ID for Lunch and then use a query that looks at it<br><br>I wrote a time clock progam a few years back and used this<br>in a table called &quot;LogInfo&quot; <br>here are a few records from it:<br><br>Employee POS055 Date &gt; 08/05/97 Tue 15:07:36<br>Punched OUT for Lunch&nbsp;&nbsp;Date &gt; 08/05/97 Tue 15:07:36<br>Employee POS055 Date &gt; 08/05/97 Tue 15:08:13<br>Punched IN for Lunch&nbsp;&nbsp;Date &gt; 08/05/97 Tue 15:08:13<br><br>I had them punch out for lunch then back in when lunch as over.<br><br>you can use the DateDiff function to subtract the times<br>I used military time so it would work over 12:00 noon.<br>