Help

Calculate the period time

2767 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Rosie_Ta
5 - Automation Enthusiast
5 - Automation Enthusiast

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,
image

4 Replies 4

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Hi Rosie, could you try a rollup field?

Screenshot 2022-06-28 at 4.16.21 PM

Rosie_Ta
5 - Automation Enthusiast
5 - Automation Enthusiast

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