i need to calculate, how mant minutes its takes to reach temperature 120(T1, time corresponding to blue color numbers), after reaching 120, how many minutes it is in between 119.5 to 120.5 deg temperature(T2, time corresponding to red colour numbers), and how many minutes after T2,(T3, time coresponding to green colour numbers).
T1 i calculated as:,=SUM(C1:INDEX($C$1:$C$25,MATCH(H8,$B$1:$B$25,0)-1))
[TABLE="class: outer_border, width: 50, align: left"]
<tbody>[TR]
[TD][TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64, align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD="align: right"]17[/TD]
[/TR]
[TR]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD="align: right"]19[/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD]Time[/TD]
[/TR]
[TR]
[TD]10:36:00[/TD]
[/TR]
[TR]
[TD]10:36:30[/TD]
[/TR]
[TR]
[TD]10:37:00[/TD]
[/TR]
[TR]
[TD]10:37:30[/TD]
[/TR]
[TR]
[TD]10:38:00[/TD]
[/TR]
[TR]
[TD]10:38:30[/TD]
[/TR]
[TR]
[TD]10:39:00[/TD]
[/TR]
[TR]
[TD]10:39:30[/TD]
[/TR]
[TR]
[TD]10:40:00[/TD]
[/TR]
[TR]
[TD]10:40:30[/TD]
[/TR]
[TR]
[TD]10:41:00[/TD]
[/TR]
[TR]
[TD]10:41:30[/TD]
[/TR]
[TR]
[TD]10:42:00[/TD]
[/TR]
[TR]
[TD]10:42:30[/TD]
[/TR]
[TR]
[TD]10:43:00[/TD]
[/TR]
[TR]
[TD]10:43:30[/TD]
[/TR]
[TR]
[TD]10:44:00[/TD]
[/TR]
[TR]
[TD]10:44:30[/TD]
[/TR]
[TR]
[TD]10:45:00[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 120"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Temp[/TD]
[/TR]
[TR]
[TD]45.5[/TD]
[/TR]
[TR]
[TD]49.7[/TD]
[/TR]
[TR]
[TD]91[/TD]
[/TR]
[TR]
[TD]106[/TD]
[/TR]
[TR]
[TD]113.5[/TD]
[/TR]
[TR]
[TD]115.6[/TD]
[/TR]
[TR]
[TD]117.8[/TD]
[/TR]
[TR]
[TD]119.6[/TD]
[/TR]
[TR]
[TD]120[/TD]
[/TR]
[TR]
[TD]119.7[/TD]
[/TR]
[TR]
[TD]119.7[/TD]
[/TR]
[TR]
[TD]119.7[/TD]
[/TR]
[TR]
[TD]119.7[/TD]
[/TR]
[TR]
[TD]119.7[/TD]
[/TR]
[TR]
[TD]120.3[/TD]
[/TR]
[TR]
[TD]108.8[/TD]
[/TR]
[TR]
[TD]102.8[/TD]
[/TR]
[TR]
[TD]54.5[/TD]
[/TR]
[TR]
[TD]48.4[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Temp diff
[TABLE="width: 120"]
<colgroup><col></colgroup><tbody>[TR]
[TD][TABLE="width: 60"]
<colgroup><col></colgroup><tbody>[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
now please help me to find T2 and T3.
H8: 120.
T1 i calculated as:,=SUM(C1:INDEX($C$1:$C$25,MATCH(H8,$B$1:$B$25,0)-1))
[TABLE="class: outer_border, width: 50, align: left"]
<tbody>[TR]
[TD][TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64, align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD="align: right"]17[/TD]
[/TR]
[TR]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD="align: right"]19[/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD]Time[/TD]
[/TR]
[TR]
[TD]10:36:00[/TD]
[/TR]
[TR]
[TD]10:36:30[/TD]
[/TR]
[TR]
[TD]10:37:00[/TD]
[/TR]
[TR]
[TD]10:37:30[/TD]
[/TR]
[TR]
[TD]10:38:00[/TD]
[/TR]
[TR]
[TD]10:38:30[/TD]
[/TR]
[TR]
[TD]10:39:00[/TD]
[/TR]
[TR]
[TD]10:39:30[/TD]
[/TR]
[TR]
[TD]10:40:00[/TD]
[/TR]
[TR]
[TD]10:40:30[/TD]
[/TR]
[TR]
[TD]10:41:00[/TD]
[/TR]
[TR]
[TD]10:41:30[/TD]
[/TR]
[TR]
[TD]10:42:00[/TD]
[/TR]
[TR]
[TD]10:42:30[/TD]
[/TR]
[TR]
[TD]10:43:00[/TD]
[/TR]
[TR]
[TD]10:43:30[/TD]
[/TR]
[TR]
[TD]10:44:00[/TD]
[/TR]
[TR]
[TD]10:44:30[/TD]
[/TR]
[TR]
[TD]10:45:00[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 120"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Temp[/TD]
[/TR]
[TR]
[TD]45.5[/TD]
[/TR]
[TR]
[TD]49.7[/TD]
[/TR]
[TR]
[TD]91[/TD]
[/TR]
[TR]
[TD]106[/TD]
[/TR]
[TR]
[TD]113.5[/TD]
[/TR]
[TR]
[TD]115.6[/TD]
[/TR]
[TR]
[TD]117.8[/TD]
[/TR]
[TR]
[TD]119.6[/TD]
[/TR]
[TR]
[TD]120[/TD]
[/TR]
[TR]
[TD]119.7[/TD]
[/TR]
[TR]
[TD]119.7[/TD]
[/TR]
[TR]
[TD]119.7[/TD]
[/TR]
[TR]
[TD]119.7[/TD]
[/TR]
[TR]
[TD]119.7[/TD]
[/TR]
[TR]
[TD]120.3[/TD]
[/TR]
[TR]
[TD]108.8[/TD]
[/TR]
[TR]
[TD]102.8[/TD]
[/TR]
[TR]
[TD]54.5[/TD]
[/TR]
[TR]
[TD]48.4[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Temp diff
[TABLE="width: 120"]
<colgroup><col></colgroup><tbody>[TR]
[TD][TABLE="width: 60"]
<colgroup><col></colgroup><tbody>[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]0:00:30[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
now please help me to find T2 and T3.
H8: 120.