elapsed time between 2 records in a report

D

Dan Leeder

I have a report that lists tasks that people have worked on with
starting and ending times. The report looks like so:

ID Task Startdate Starttime Enddate Endtime ElapsedTime
1 Receiving 9/9/03 22:00 9/10/03 1:00 3:00
2 Picking 9/10/03 2:00 9/10/03 4:00 2:00

How do I calculate the time between records(endtime of record 1 -
starttime of record 2) so the report looks like so:

ID Task Startdate Starttime Enddate Endtime ElapsedTime
1 Receiving 9/9/03 22:00 9/10/03 1:00 3:00
Time between tasks: 1:00
2 Picking 9/10/03 2:00 9/10/03 4:00 2:00

Any ideas? Thanks

Dan
 
Top