Calculate the period time

Hi Rosie, not entirely sure what you’re trying to do here.

I’m going to assume that you want the difference (in hours) between the earliest date time and the latest date time of the linked records

If so, I would do the following:

1. Create a rollup field for the Date Transaction field in the Position Ref table, and use the aggregation formula “max(values)” called “Max Date”
2. Create a rollup field for the Date Transaction field in the Position Ref table, and use the aggregation formula “min(values)” called “Min Date”

This would give us two columns which show the earliest and latest date times

After that, I would create a formula field with the following formula: DATETIME_DIFF({Max Date}, {Min Date}, "hours")

This should do what you’re looking for I think

Hi,
But I can not use Max(values), Min(values) for Date and time format???
Regards,

Hi Rosie, could you try a rollup field?

Hi,
I done it.
Thank you so much.
Regards,