Not sure if this will work, but attached a gif of table

I actually have the time broken down to blocks of 15 minutes where 12:00AM to 12:15 as block 2, 12:15AM to 12:30AM as block 3, 12:30AM to 12:45 as block 4 etc.. The days worked are broken down to a week number and day number since 01/01/2000 (Monday is day 1)

I have a fKey to employee, week number, day number, timein and time out

> > Table with employee's starting time and ending time recorded for performing tasks.

> > Times are recorded to the nearest 15 minutes such as 9:15 to 10:30 etc.

> >

> > An example would be employee scheduled for tasks from

> > 8:00AM to 9:00AM (task 1)

> > 9:30AM to 11:00AM (task 2)

> > 11:00AM to 12:30PM (task 3)

> > 2:00PM to 3:00PM (task 4)

> > 4:15PM to 6:00PM (task5)

> >

> >

> >

> > What is needed is to determine all thoes employee's who have a lapse of 15 minutes to 1.5 hours between tasks, so the above I would need to identify that the employee lapse of time of lapse time of 30 minutes from 9:00AM to 9:30AM (task2 to task 3) and lapse time of 1hr 15 minutes from 3:00PM to 4:15PM (task4 to task5)

> >

> > What is happening is that we are scheduling employees during the day and if we schedule less than 1 hour 30 minutes between tasks, we are required to compensate them for that time. If the lapse time is 1 hour 30 minutes or more, we are not required. Like wise if the lapse time is 0 (back to back) such as task 1 ending at 11:00AM and then task 2

> > starting at 11:00AM M there is no lapse and therefore not required.

> >

> > Looking for the best solution to identify all employees on a give day that would fall into these lapse of times from 15 minutes to 1 hour 30 minutes.

> >

> > Thanks in advance for all suggestions.

>

> Are the times in DateTime columns (which are easy to compute) or Char type columns? There's no Time data type in VFP.

> Is every row a different task than the preceding row, timewise? Can the same task resume after a break?

> Are the task neatly numbered 1,2,3 like you show?

> What is he Primary Key of the table?

>

> -Anders