Instead of adding 8 hours, add the appropriate number of hours, taken from the empoyee's data.
>Well, once again, I will try to tap into the knowledgebase of this forum for some much needed answers.
>
>I have most of my time card processing program working, but am at a loss as to how to handle on situation.
>
>We have three different types of data for employees clocking in:
>(1) Scheduled Start Time-this is "sometimes" in a field called Employee.ShStrt.
>(2) Actual Start Time
>(3) Effective Start Time, which is one of the two above choices.
>
>We have three different types of data for employees clocking out:
>(1) Scheduled End Time
>(2) Actual End Time
>(3) Effective End Time, which is one of the two above choices.
>
>We have no problem in determining the Scheduled Start Time; however, we do have a problem in determining the
Scheduled End Time. We use this value to determine whether or not the employee clocked out early or late.
>
>We know the actual end time, based on the clock out, but we need to know the time the employee should have clocked out. My predecessor just added 8 hours to the Scheduled Start Hour to determine the Scheduled End Hour. Unfortunately, some people work 6, 7, or 8 hours, and some others may work 10 to 12 hours, so adding 8 hours doesn't quite cover all circumstances.
>
>I need the Scheduled End Hour and Scheduled End Minute to determine if the employee was early or late in clocking out.