Formula to read a previous field

[wolverinec7]

is there any way i can get a formula to work out the difference between record 1 of column A with record 2 of column B.
for example we're trying to work out how long it takes an engineer to get from one job to another.

job number dispatch date time complete date time formula
1 1/12/05 10:10 1/12/05 11.10 -
2 1/12/05 12:10 1/12/05 13.25 60 mins
3 1/12/05 14.35 1/12/05 15.00 70 mins

i'm at a loss........

 

[lbass]

It looks like you mean record 2 of column A and record 1 of column B...

Let's assume you are calculating within a larger group. You would then use a formula like:

if {table.groupfield} = previous({table.groupfield}) then
datediff("n",previous({table.completedatetime}),{table.dispatchdatetime})

-LB