----- Original Message -----
Sent: Sunday, November 06, 2005 9:24
PM
Subject: Re: [AccessDevelopers] Dead
Time
Bryan,
Sample query given below, should get you the dead
time in minutes (lapsed between end of previous task and start of
current task).
T_Events is the name of table, Start and End are
Date/Time type fields and PersonID is the field identifying the person to
whom the task pertains. Field named Task is also available in the table but
does not play any role in the SQL statement.
Best wishes,
A.D.Tejpal
Sample Query
===================================
SELECT T_Events.*, 1440*([Start]-(Select Max(End)
From T_Events As T1 Where T1.PersonID = T_Events.PersonID And T1.End <=
T_Events.Start)) AS DeadTime
FROM T_Events
ORDER BY
T_Events.PersonID, T_Events.Start;
===================================
----- Original Message -----
Sent: Friday, November 04, 2005
00:51
Subject: [AccessDevelopers] Dead
Time
Hi,
I use a union query that tracks associates work
chronologically.
I've been asked to add Dead Time between the
tasks.
Task Start End
Task1 07:00 07:30
Task2 07:35
08:00
Between Task1 and Task2 there is Dead Time of 5
minutes.
I've dumped the query results in a temp table, but how
should
I capture the Dead
Time?
Thanks,
Bryan
