calculate time series

[#1]

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! :smiling_face_with_smiling_eyes:

[#2]

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.