Curve Behavior

[arishy]

In the attached sheet you will find how I am getting the time it takes a room temperature to go from H to L when the Air conditional goes ON then it shows how long it takes room temperatures go from L to H. The test data shows fake data to simplify testing.
I need to create a macro to do the hard work. The required output is two lists.
HtoL_list = 30,30 this is because the data represent TWO cycles H-L-H twice
LtoH_list = 30,30 this is because the data represent TWO cycles H-L-H twice

In real life the data will represents 24 hours with a lot of cycles

Any help will greatly appreciated. I believe this can be popular custom function with your help

 

[vletm]

arishy​

I gotta change Your logic.
Even a sample or fake data should be more realistic.
eg. Your 'data' gives an idea that You'll get temperatures with two decimals.
Newer (right side) version gives third time values.
One challenge based with Your datas: Is there really always five minutes gap between times?

 

[arishy]

The recording time of the temperature is every 5 minutes. Look at the timestamp. It tells you the value at this time is x

 

[vletm]

arishy​

Yes, Your fake datas recording times are ... eg =B2+5/1440
My point was while someone uses this with real data.
My sample uses Your ... sample data.