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))
<tbody>
</tbody> 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))
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody> </tbody> |
<tbody> </tbody> |
<colgroup><col></colgroup><tbody> </tbody> | Temp diff
<colgroup><col></colgroup><tbody> </tbody> |
<tbody>
</tbody>
H8: 120.