AnsweredAssumed Answered

Calculated Time fields results

Question asked by paulo.casa on Nov 20, 2009
Latest reply on Nov 23, 2009 by comment_1

Title

Calculated Time fields results

Post

Hello

 

I have theexperimental version of Filemaker Pro 10 for Windows. I am trying to see if Icould solve this problem:

 

In mydatabase I have a few records and one of the fields is a time value.

Imagine 15 records and  witch one with a different time value.

How can Icalculate de difference between time values from one record to another, no matterthe sort order and save the result on a field: I think it shouldbe something like this but I can put this in Filemaker’s language

The time valueof the second record less the time value of the first record;

The time valueof the third record less the time value of the second record

And so one…..UntilI reach the last record

Is itpossible to do. Can someone help me?

 

Regards

Paulo

Outcomes