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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top