Temperature log analyses

[mottyb]

On a temperature log that gradually goes from up to cooking temperature, than down to freezing.
I want to extract information and get a report as to how long it took to reach 60F, than how long it took to reach 160F, than how long it to to go back down to 0.
Thank you so much.

Aug 2021.xlsx
	A	B
10	8/31/2021 17:44	25
11	8/31/2021 17:47	24
12	8/31/2021 17:49	24
13	8/31/2021 17:52	24
14	8/31/2021 17:55	24
15	8/31/2021 17:58	24
16	8/31/2021 18:01	24
17	8/31/2021 18:04	24
18	8/31/2021 18:07	24
19	8/31/2021 18:10	24
20	8/31/2021 18:13	25
21	8/31/2021 18:16	25
22	8/31/2021 18:19	25
23	8/31/2021 18:22	25
24	8/31/2021 18:25	25
25	8/31/2021 18:28	25
26	8/31/2021 18:31	25
27	8/31/2021 18:34	25
28	8/31/2021 18:37	25
29	8/31/2021 18:40	25
30	8/31/2021 18:43	25
31	8/31/2021 18:46	25
32	8/31/2021 18:49	25
33	8/31/2021 18:52	25
34	8/31/2021 18:55	25
35	8/31/2021 18:58	25
36	8/31/2021 19:01	26
37	8/31/2021 19:04	26
38	8/31/2021 19:07	26
39	8/31/2021 19:10	26
40	8/31/2021 19:13	26
41	8/31/2021 19:16	26
42	8/31/2021 19:19	26
43	8/31/2021 19:22	26
44	8/31/2021 19:25	26
45	8/31/2021 19:28	26
46	8/31/2021 19:31	26
47	8/31/2021 19:34	27
48	8/31/2021 19:37	27
49	8/31/2021 19:40	27
50	8/31/2021 19:43	27
51	8/31/2021 19:46	27
52	8/31/2021 19:49	27
53	8/31/2021 19:52	27
54	8/31/2021 19:55	27
55	8/31/2021 19:58	27
56	8/31/2021 20:01	28
57	8/31/2021 20:04	28
58	8/31/2021 20:07	28
59	8/31/2021 20:10	28
60	8/31/2021 20:13	29
61	8/31/2021 20:16	29
62	8/31/2021 20:19	30
63	8/31/2021 20:22	31
64	8/31/2021 20:25	32
65	8/31/2021 20:28	33
66	8/31/2021 20:31	35
67	8/31/2021 20:34	38
68	8/31/2021 20:37	41
69	8/31/2021 20:40	44
70	8/31/2021 20:43	47
71	8/31/2021 20:46	50
72	8/31/2021 20:49	53
73	8/31/2021 20:52	55
74	8/31/2021 20:55	57
75	8/31/2021 20:58	59
76	8/31/2021 21:01	62
77	8/31/2021 21:04	64
78	8/31/2021 21:07	66
79	8/31/2021 21:10	68
80	8/31/2021 21:13	69
81	8/31/2021 21:16	71
82	8/31/2021 21:19	73
83	8/31/2021 21:22	75
84	8/31/2021 21:25	77
85	8/31/2021 21:28	78
86	8/31/2021 21:31	80
87	8/31/2021 21:34	82
88	8/31/2021 21:37	83
89	8/31/2021 21:40	85
90	8/31/2021 21:43	86
91	8/31/2021 21:46	88
92	8/31/2021 21:49	89
93	8/31/2021 21:52	91
94	8/31/2021 21:55	92
95	8/31/2021 21:58	94
96	8/31/2021 22:01	95
97	8/31/2021 22:04	96
98	8/31/2021 22:07	98
99	8/31/2021 22:10	99
100	8/31/2021 22:13	100
101	8/31/2021 22:16	101
102	8/31/2021 22:19	102
103	8/31/2021 22:22	104
104	8/31/2021 22:25	104
105	8/31/2021 22:28	105
106	8/31/2021 22:31	107
107	8/31/2021 22:34	108
108	8/31/2021 22:37	109
109	8/31/2021 22:40	110
110	8/31/2021 22:43	111
111	8/31/2021 22:46	112
112	8/31/2021 22:49	113
113	8/31/2021 22:52	114
114	8/31/2021 22:55	115
115	8/31/2021 22:58	116
116	8/31/2021 23:01	117
117	8/31/2021 23:04	118
118	8/31/2021 23:07	119
119	8/31/2021 23:10	120
120	8/31/2021 23:13	121
121	8/31/2021 23:16	122
122	8/31/2021 23:19	123
123	8/31/2021 23:22	124
124	8/31/2021 23:25	125
125	8/31/2021 23:28	126
126	8/31/2021 23:31	127
127	8/31/2021 23:34	128
128	8/31/2021 23:37	129
129	8/31/2021 23:40	129
130	8/31/2021 23:43	131
131	8/31/2021 23:46	131
132	8/31/2021 23:49	132
133	8/31/2021 23:52	133
134	8/31/2021 23:55	134
135	8/31/2021 23:58	135
136	9/1/2021 0:01	136
137	9/1/2021 0:04	137
138	9/1/2021 0:07	138
139	9/1/2021 0:10	139
140	9/1/2021 0:13	140
141	9/1/2021 0:16	141
142	9/1/2021 0:19	142
143	9/1/2021 0:22	143
144	9/1/2021 0:25	143
145	9/1/2021 0:28	144
146	9/1/2021 0:31	150
147	9/1/2021 0:34	148
148	9/1/2021 0:37	146
149	9/1/2021 0:40	146
150	9/1/2021 0:43	145
151	9/1/2021 0:46	144
152	9/1/2021 0:49	142
153	9/1/2021 0:52	140
154	9/1/2021 0:55	138
155	9/1/2021 0:58	136
156	9/1/2021 1:01	133
157	9/1/2021 1:04	130
158	9/1/2021 1:07	127
159	9/1/2021 1:10	124
160	9/1/2021 1:13	122
161	9/1/2021 1:16	119
162	9/1/2021 1:19	116
163	9/1/2021 1:22	113
164	9/1/2021 1:25	110
165	9/1/2021 1:28	107
166	9/1/2021 1:31	104
167	9/1/2021 1:34	102
168	9/1/2021 1:37	99
169	9/1/2021 1:40	96
170	9/1/2021 1:43	94
171	9/1/2021 1:46	91
172	9/1/2021 1:49	89
173	9/1/2021 1:52	86
174	9/1/2021 1:55	84
175	9/1/2021 1:58	82
176	9/1/2021 2:01	80
177	9/1/2021 2:04	78
178	9/1/2021 2:07	76
179	9/1/2021 2:10	75
180	9/1/2021 2:13	73
181	9/1/2021 2:16	71
182	9/1/2021 2:19	70
183	9/1/2021 2:22	68
184	9/1/2021 2:25	67
185	9/1/2021 2:28	65
186	9/1/2021 2:31	64
187	9/1/2021 2:34	63
188	9/1/2021 2:37	61
189	9/1/2021 2:40	60
190	9/1/2021 2:43	59
191	9/1/2021 2:46	58
192	9/1/2021 2:49	57
193	9/1/2021 2:52	56
194	9/1/2021 2:55	55
195	9/1/2021 2:58	53
196	9/1/2021 3:01	52
197	9/1/2021 3:04	51
198	9/1/2021 3:07	50
199	9/1/2021 3:10	48
200	9/1/2021 3:13	47
201	9/1/2021 3:16	46
202	9/1/2021 3:19	45
203	9/1/2021 3:22	44
204	9/1/2021 3:25	42
205	9/1/2021 3:28	42
206	9/1/2021 3:31	41
207	9/1/2021 3:34	40
208	9/1/2021 3:37	39
209	9/1/2021 3:40	38
210	9/1/2021 3:43	37
211	9/1/2021 3:46	36
212	9/1/2021 3:49	36
213	9/1/2021 3:52	35
214	9/1/2021 3:55	34
215	9/1/2021 3:58	34
216	9/1/2021 4:01	33
217	9/1/2021 4:04	32
218	9/1/2021 4:07	32
219	9/1/2021 4:10	32
220	9/1/2021 4:13	32
221	9/1/2021 4:16	32
222	9/1/2021 4:19	31
223	9/1/2021 4:22	31
224	9/1/2021 4:25	31
225	9/1/2021 4:28	31
226	9/1/2021 4:31	30
227	9/1/2021 4:34	30
228	9/1/2021 4:37	30
229	9/1/2021 4:40	30
230	9/1/2021 4:43	30
231	9/1/2021 4:46	30
232	9/1/2021 4:49	29
233	9/1/2021 4:52	29
234	9/1/2021 4:55	29
235	9/1/2021 4:58	29
236	9/1/2021 5:01	29
237	9/1/2021 5:04	29
238	9/1/2021 5:07	29
239	9/1/2021 5:10	29
240	9/1/2021 5:13	29
241	9/1/2021 5:16	29
242	9/1/2021 5:18	29
243	9/1/2021 5:21	29
244	9/1/2021 5:24	29
245	9/1/2021 5:27	29
246	9/1/2021 5:30	29
247	9/1/2021 5:33	29
248	9/1/2021 5:36	28
249	9/1/2021 5:39	28
250	9/1/2021 5:42	28
251	9/1/2021 5:45	28
252	9/1/2021 5:48	28
253	9/1/2021 5:51	28
254	9/1/2021 5:54	28
255	9/1/2021 5:57	27
256	9/1/2021 6:00	27
257	9/1/2021 6:03	27
258	9/1/2021 6:06	27
259	9/1/2021 6:09	27
260	9/1/2021 6:12	26
261	9/1/2021 6:15	26
262	9/1/2021 6:18	26
263	9/1/2021 6:21	25
264	9/1/2021 6:21	25
265	9/1/2021 6:23	25
266	9/1/2021 6:24	0
20210831-174359

 

[JamesCanale]

You data set never got up to 160°. I set this to find the max temp.

MrExcelPlayground4.xlsx
	A	B	C	D	E	F	G
1	8/31/2021 17:44	25			Time	Temp	Duration
2	8/31/2021 17:47	24		Start	8/31/2021 17:44	25°	x
3	8/31/2021 17:49	24		60°	8/31/2021 21:01	62°	3:17
4	8/31/2021 17:52	24		max	9/1/2021 0:31	150°	3:29
5	8/31/2021 17:55	24		0°	9/1/2021 6:24	0°	5:53
6	8/31/2021 17:58	24
7	8/31/2021 18:01	24
8	8/31/2021 18:04	24
9	8/31/2021 18:07	24
10	8/31/2021 18:10	24
11	8/31/2021 18:13	25
12	8/31/2021 18:16	25
13	8/31/2021 18:19	25
14	8/31/2021 18:22	25
15	8/31/2021 18:25	25
16	8/31/2021 18:28	25
17	8/31/2021 18:31	25
18	8/31/2021 18:34	25
19	8/31/2021 18:37	25
20	8/31/2021 18:40	25
21	8/31/2021 18:43	25
22	8/31/2021 18:46	25
23	8/31/2021 18:49	25
24	8/31/2021 18:52	25
25	8/31/2021 18:55	25
26	8/31/2021 18:58	25
27	8/31/2021 19:01	26
28	8/31/2021 19:04	26
Sheet24

Cell Formulas
Range	Formula
E2:F2	E2	=A1
E3	E3	=INDEX($A$1:$A$257,MATCH(D3,$B$1:$B$257,1)+1)
F3	F3	=INDEX($B$1:$B$257,MATCH(D3,$B$1:$B$257,1)+1)
G3:G5	G3	=E3-E2
E4	E4	=INDEX($A$1:$A$257,MATCH(MAX($B$1:$B$257),$B$1:$B$257,0))
F4	F4	=INDEX($B$1:$B$257,MATCH(MAX($B$1:$B$257),$B$1:$B$257,0))
E5	E5	=INDEX($A$1:$A$257,MATCH(D5,$B$1:$B$257,0))
F5	F5	=INDEX($B$1:$B$257,MATCH(D5,$B$1:$B$257,0))