new column to calculate different rows

[Raghadhq]

Hi there

i want to add a new column to calculate the different in time 

Arrival	5/7/2023 6:44:00 AM
Departure	5/7/2023 2:54:00 AM

how can i do it?

thanks

[alexnajm · Accepted solution]

Is this always the structure of the data? If so, this will work:

[Raghadhq]

yes it's always comes in different row ( follow each other )

[alexnajm]

Understood - well hopefully you have a column to Group By then! Otherwise you might need to use a Multi-Row Formula to create those groupings so the difference calculations don't overlap. The above will still work - you just need to select that grouping column!

[Raghadhq]

it worked thanks!!