Start in cell B2

Read down until we find a value <1

At this row grab the data from Column A

Refrnc:= (Power On)

At this same row, in Column C, start

reading down until we find the lowest

point in a dip of value

At this row grab value from Column A

Sutract this new value from Power On

Result = (Opening Time)?

Start in last value found in Column A

In the same row in Column B,

go up until a value of <1 is found.

Grab value at this row in Column A

(Power Off)

For ex. Row 12000

Go to Column H of this row and

place formula:

H11999 - E12000

Fill down column H to the

last cell containing data.

Use Column A as reference for

last Cell?

At row 12000, scroll down values

until < -2

Grab value from Column A in same row

Power Off - Column A Value = Closing Time?

Beginning at E12000

scroll down values until we find

>144 <156 ?

Grab value from this row in Column A

Power Off - Value in Column A = Venting Time ?

Your Quote. I am not grasping this:

"Go to column "H" and input a formula

to subtract data in this row but column "E"

(OUT_PRESS) from the data in column "H" just

above this row."

Also, 150 ±5

Does that = >144 <156

Sorry if I just repeated you in other words.

I needed to repeat you in my own words

to see if I had a chance of grasping what you

are after...

Thanks,

Tom

## Like this thread? Share it with others