J
JC
Hi,
I set out to build an excel spreadsheet for my exercise schedule on a walking
machine. The schedule basically has me walking for 30 seconds, jogging for 50
seconds, walking for 30 seconds, jogging for 150 seconds etc etc.
I wanted a table that gave me the finishing time for each segment of the
exercise as the clock on the trainer only shows elapsed time.
I couldn't find a way to have Excel do the sums such that I started with 00:00
in A2 and then each successive cell followed the format = a2+30 seconds, =a3+50
seconds etc with all cells formatted as mm:ss.
In the end I made it a text field and simply typed in the finishing time for
each segment of the exercise - ie 0 min 30 secs, 1 min 20 secs etc etc.
I figure that there must be a way to do this and I just haven't found it yet.
Does anyone have any ideas how to do it?
I set out to build an excel spreadsheet for my exercise schedule on a walking
machine. The schedule basically has me walking for 30 seconds, jogging for 50
seconds, walking for 30 seconds, jogging for 150 seconds etc etc.
I wanted a table that gave me the finishing time for each segment of the
exercise as the clock on the trainer only shows elapsed time.
I couldn't find a way to have Excel do the sums such that I started with 00:00
in A2 and then each successive cell followed the format = a2+30 seconds, =a3+50
seconds etc with all cells formatted as mm:ss.
In the end I made it a text field and simply typed in the finishing time for
each segment of the exercise - ie 0 min 30 secs, 1 min 20 secs etc etc.
I figure that there must be a way to do this and I just haven't found it yet.
Does anyone have any ideas how to do it?