Duration between group of dates

[nbento]

Hi,

I need to calculate the duration in the format (days hh:nn:ss) between a group of dates. 
The data is in this format:

For each "numero", i need to calculate de duration beteween the first date in colunm "dataEntrada" and the last date in colunm "dataLacrado".

Any idea?

Thanks

[nbento]

Hi,

That gives me the duration line to line. I want the duration, for each "numero".
So, first I have to check the first date in colunm "dataEntrada" and the last date in colunm "dataLacrado".

After that, calculte the duration.... (for each "numero"). Most likely, i have to creat a new calculate table... but, I'not getting the complet formula for this.

Easy to say!! 🙂

[amitchandak]

@nbento , Try a new column like

[dataEntrada] - [dataLacrado]