I need a formula to calculate the date difference between dates within the same field.  The report lists work orders done by each of our drivers (we're a hauling company) and their completion times.  I would like to be able to calculate the difference between start times, but it seems to be more complicated than a datediff formula since these times are within the same field.  I feel like there must be some way to order or sort the orders based on completion time so that I can find the times between the 1st and 2nd order of the day, the 2nd and 3rd, ...second to last and the last.

 

I am fairly new at crystal reports.  Any help would be greatly appreciated and thank you in advance for your help.

I want to be able to find the time per work order by finding the time difference between the nth and (n+1)th work order start time.  This is done for each driver for each day.

 

Driver

  Date

    Work Order details

 

Here's an example:

 

Robert

  7/25/2011

    Job 11678  6:15am  (start time)  etc..

    Job 11717  7:25am  (start time)  etc..

    Job 11725  10:25am (start time) etc..

 

  Driver Clock in: 6:00am

  Driver Clock out: 6:15pm

------

Next Driver and so on

 

 All of the start times are taken from the field {COST_COSH_VIEW.Start_Time}

 

I want to make a formula to show that the first job from 6:15-7:25am took 1h10min, but I don't know how to do that other than manually entering stop times into a different field, essentially doubling the data entry.  Thank you again for your help.

 

 

Ideally, I want to calculate their average time per route.  I can do this if I reenter each start time (besides the first one) as a stop time for the previous route, but of course it takes twice as long.  This may be a lost cause or maybe there's another workaround.  Either way, thank you for your help.