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