If ( GetNthRecord ( Area ; Get ( RecordNumber ) - 1 = Area ; Time - GetNthRecord ( Time ; Get ( RecordNumber ) - 1 ) )
Make time your result type if you want to format the field on your layout to show minutes.
If you choose number, as the result type, you will also need to divide by 60 to convert elapsed seconds into minutes.
Such an active forum!! Replies within minutes.... Thanks.
I am getting this error "There are too many parameters in this function"
Do I have to create a field named "RecordNumber"?
My mistake, left out a parenthesis:
If ( GetNthRecord ( Area ; Get ( RecordNumber ) - 1 ) = Area ; Time - GetNthRecord ( Time ; Get ( RecordNumber ) - 1 ) )
"RecordNumber" is a parameter passed to the Get function to tell it what value to "Get". If you look up Get Functions in FileMaekr Help, you'll find that there is a very long list of parameters you can use with it to get all kinds of different values.
Also, make sure that this calculation field reads as "unstored". You may need to click the storage options button to select that option.
Thanks for your quick & accurate reply...