249430_en-US

liliconcom

calculate time series

Hey how are you?
I need your help.

I have data of one of our valve.
When its open the value is 1, and when its close the value is zero.

I want to calculate the time it was close - at each session.
for example:
Between the last opening and the opening after that - 41 minutes passed.
That is, the valve was closed for 41 minutes.
What code can I write to calculate this?

Thank you!:cara_que_sonríe_con_ojos_sonrientes:

Re: calculate time series

Hi,

I hope I understand the question.

Please see attached a data table with formulas - I think you dont have to use JSL in this case, just simple formulas in data table.

If I'm missing something, please attach your data.

 

BR,

Tom.