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?
--

Cheers . . . JC

=A2+TIME(,,30)
=A3+TIME(,,50)

Regards,
Stefi

€žJC€� ezt Ã*rta:

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?
--

Cheers . . . JC

Stefi,

Many thanks! That worked like a charm.

JC

On Thu, 16 Mar 2006 02:01:26 -0800, Stefi
wrote:

=A2+TIME(,,30)
=A3+TIME(,,50)

Regards,
Stefi

„JC” ezt írta:

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?
--

Cheers . . . JC

You are welcome! Thanks for the feedback!
Stefi


€žJC€� ezt Ã*rta:

Stefi,

Many thanks! That worked like a charm.

JC

On Thu, 16 Mar 2006 02:01:26 -0800, Stefi
wrote:

=A2+TIME(,,30)
=A3+TIME(,,50)

Regards,
Stefi

€žJC€� ezt Ã*rta:

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?
--

Cheers . . . JC