Problem with Negative differences of Time

[OldSwimmer1650]

I want column G to display the change in time from the previous days run. If I run faster that is a positive number, if slower that's a negative number. The problem is with negative numbers. The positive numbers are fine.

D Previous Day should be Delta Previous Day (G5)

Column I is what I'm looking to display.

I understand that subtracting a larger time from a smaller time creates a very large number(not what i want) G16

TimeQuestions.xlsx
	B	C	D	E	F	G	H	I
3
4							General Format	TYPED IN BY HAND
5	Date	Distance	Ave HR	Max HR	Time	D Previous Day	Convert to Sec's	What I'm Looking for
6	5/1/2022	#N/A	#N/A	#N/A	#N/A
7	5/2/2022	4.04	103	131	01:28:26	#N/A	#N/A
8	5/3/2022	4.04	84	113	01:28:21	00:00:05	5	00:00:05
9	5/4/2022	4.04	93	122	01:24:32	00:03:49	229	00:03:49
10	5/5/2022	4.04	105	129	01:15:26	00:09:06	546	00:09:06
11	5/6/2022	4.04	106	133	01:12:01	00:03:25	205	00:03:25
12	5/7/2022	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
13	5/8/2022	4.08	86	112	01:26:30	#N/A	#N/A
14	5/9/2022	4.04	114	160	01:19:00	00:07:30	450	00:07:30
15	5/10/2022	4.05	118	143	01:10:41	00:08:19	499	00:08:19
16	5/11/2022	4.05	107	136	01:15:53	##################	-312	-00:05:12
17
Sheet1

Cell Formulas
Range	Formula
G7:G16	G7	=F6-F7
H7:H16	H7	=HOUR(F6)*3600+MINUTE(F6)*60+SECOND(F6)-(HOUR(F7)*3600+MINUTE(F7)*60+SECOND(F7))

 

[Max1616]

I'm sure someone on here will think of a better solution than mine. But this seems to be working for me:

=IF(F8>F7,"-"&TEXT(MAX(F7:F8)-MIN(F7:F8),"HH:MM:SS"),TEXT(MAX(F7:F8)-MIN(F7:F8),"HH:MM:SS"))