Is there a simple way to record optional subtotals?

[JenniferMurphy]

I am trying to get in better shape. One part of my regimen is running (jogging). I usually just go out and run one of several routes in our neighborhood that I have mapped out with Google Maps so I know the distance. I take a stopwatch and time the run. When I get back, I log the date, distance, and time in a spreadsheet which then calculates the MpH and Min/Mile.

Once in awhile, I try to push it on part of the route to see if I can build up my overall speed. One loop around one block is about 2/3 mile, so I may run a warm-up lap, then a lap as fast as I can go, and then one or more moderate laps. My stopwatch has a lap timer so as I complete each lap, I can push the lap button. When I get home, I can record the times for each lap.

Here's some recent data:

R/C	C	D	E	G	H	I	J
19	Day	Date	ToD	Dist	Time	MpH	Min/Mi
20	Fri	9/21/18	7:03 PM	2.25 mi	0:35:13	3.83	15.65
21	Wed	9/19/18	7:10 PM	0.69 mi	0:10:37	3.90	15.39
22	=	=	=	0.69 mi	0:08:31	4.86	12.34
23	=	=	=	0.69 mi	0:11:16	3.67	16.33
24	=	=	=	4.32 mi	1:05:37	3.95	15.19
25	Mon	9/17/18	6:55 PM	2.25 mi	0:34:40	3.89	15.41

<tbody>
</tbody>

Rows 20 and 25 do not have laps. It's just one time for the total distance.

Rows 21-23 are three laps done one after the other. Row 24 is the sum of those 3 laps.

I had to manually code the sums. Is there a better way?

Thanks

 

[RoryA]

Row 24 looks like a sum of rows 20 to 23 to me?

If you fill in the date and time for each row, you could use a pivot table. Or there are apps for this kind of thing.