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:

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

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.