delete from consecutive lines

[deeps84]

I need some help with a particular crystal report

my report looks like this

work oder start time end time time b/w work orders
100 10:00 0:00
100 0:00 12:00
101 12:30 0:00 1:30 hrs
101 0:00 1:00

I want to calculate that 1:30 hours that is 12:00(end time of first job)- 12:30(start time of next job)

Thanks

 

[hilfy]

Try something like this:

{table.start_time} - previous({table.end_time})

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.