Put your target time in A20, and in B20 add =$A$20*COLUMN(A20)/16, then copy
across to Q209.

I input a target time of 4:32, and got values of 00:17, 00:34,00:52, etc.
<vbg

--

HTH

RP
(remove nothere from the email address if mailing direct)


"excelnewbie" wrote in message
...
I'm developing a workout programs for runners. I need a spreadsheet that
will allow a user to enter min/seconds that is their target for running a
mile.

Then I need a formula that will provide intervals at every 16th of the
mile
of what there time should be.

Any help. I thought i knew how to format to show min/sec but i'm having
all
kinds of problems

THANKS!