> 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.

Hi Ron,

I have pasted sample code from the DateTime() function below:

***

This first example stores the Datetime for the New Year to a variable named tNewyear, and stores the current Datetime to a variable named tToday. The number of seconds between the current Datetime and the New Year is then displayed.

The second example uses DATETIME( ) to create a year 2000-compliant DateTime value.

tNewyear = DATETIME(YEAR(DATE( ) ) + 1, 1, 1) && Next New Year

tToday = DATETIME( )

nSecondstonewyear = tNewyear - tToday

CLEAR

? "There are " + ALLTRIM (STR(nSecondstonewyear)) ;

+ " seconds to the next New Year."

***

You should be able to use the DateTime() function to calculate the differences in the task times.

Hope this helps,

Neil