Calculate the period time

[Rosie_Ta]

Hi everyone,
I’m Rosie,
I have a issue which I need your help. I have a lot of time by link data from another sheet (attached a photo). Now, I want to calculate the period time (calculate the number of hours) by take the last day except the first day, which have on the column and the first row.
Please help me if you have any ideas for the issue.
Regards,

[TheTimeSavingCo]

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

[Rosie_Ta]

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

[TheTimeSavingCo]

Hi Rosie, could you try a rollup field?

[Rosie_Ta]

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