Help with training log.

[Lewis Campbell]

I'm trying to make up a spreadsheet that I can use for speed work at the track.

What has me stumped is:-

How to convert from regular time, like 1 min 37secs, to decimal time, like 1.62 mins?

Is there a formula that will enable me to do this?

Your help will be appreciated.

Lewis.

*******************************

[Larry McMahan]

Lewis Campbell <limeylew@yahoo.com> writes:
: I'm trying to make up a spreadsheet that I can use for speed work at the track.

: What has me stumped is:-

: How to convert from regular time, like 1 min 37secs, to decimal time, like 1.62 mins?

: Is there a formula that will enable me to do this?

: Your help will be appreciated.

: Lewis.

: *******************************

Why do you want to do this? I have an excel spreadsheet that I use, and all my times are as
hh:mm:ss.t. I have no problem and the spreadsheet does all the division for pact times
correctly. WTP?

Larry

[David Hallswort]

Have you looked at the running log created by David Hays for Dead Runner's Society?

http://www.blarg.net/~dhays/running/runlog/runlog.html

This baby does it all, so if it doesn't do what you want, it'll sure show you an alternate method.

Best, Dave

--
To email, remove SPAM.com and replace with wadham DOT oxford DOT ac DOT uk

[Lewis Campbell]

Larry McMahan <mcmahan@spike.cup.hp.com> wrote in message news:<3f70a369@usenet01.boi.hp.com>...
> Lewis Campbell <limeylew@yahoo.com> writes:
> : I'm trying to make up a spreadsheet that I can use for speed work at the track.
>
> : What has me stumped is:-
>
> : How to convert from regular time, like 1 min 37secs, to decimal time, like 1.62 mins?
>
> : Is there a formula that will enable me to do this?
>
> : Your help will be appreciated.
>
> : Lewis.
>
> : *******************************
>
> Why do you want to do this? I have an excel spreadsheet that I use, and all my times are as
> hh:mm:ss.t. I have no problem and the spreadsheet does all the division for pact times
> correctly. WTP?
>
> Larry

************************************************

Thanks, Larry, the problem is that I do not seem to be able to format a cell to do " hh:mm:ss.t. "

When I try, the date also appears and therefore screws up my calculations.

Lewis.

***************************

[Lewis Campbell]

"David Hallsworth" <david.hallsworth@SPAM.com> wrote in message news:<bkqebf$7lj$1@news.ox.ac.uk>...
> Have you looked at the running log created by David Hays for Dead Runner's Society?
>
> http://www.blarg.net/~dhays/running/runlog/runlog.html
>
> This baby does it all, so if it doesn't do what you want, it'll sure show you an alternate method.
>
> Best, Dave

***************************************

Thanks, Dave, this looks like a SUPER log but it is far more complex than what I need.

If I could format a cell so that I can enter a time, such as 19.36 (for a 5K) and then, in
subsequent cells, break that down to 1 mile pace, 1/2 mile pace and 1/4 mile pace, I'd be happy.

Every time I have tried to format the first cell, it has ended up with a 'date and time', which then
does not allow me to make my calculations.

Lewis.

*******************************

[Mike R.]

"Lewis Campbell" <limeylew@yahoo.com> wrote in message
news:e68f926d.0309240320.10d22715@posting.google.com...
> Larry McMahan <mcmahan@spike.cup.hp.com> wrote in message
news:<3f70a369@usenet01.boi.hp.com>...
> > Lewis Campbell <limeylew@yahoo.com> writes:
> > : I'm trying to make up a spreadsheet that I can use for speed work at the track.
> >
> > : What has me stumped is:-
> >
> > : How to convert from regular time, like 1 min 37secs, to decimal time, like 1.62 mins?
> >
> > : Is there a formula that will enable me to do this?
> >
> > : Your help will be appreciated.
> >
> > : Lewis.
> >
> > : *******************************
> >
> > Why do you want to do this? I have an excel spreadsheet that I use, and all my times are as
> > hh:mm:ss.t. I have no problem and the spreadsheet does all the division for pact times
> > correctly. WTP?
> >
> > Larry
>
> ************************************************
>
> Thanks, Larry, the problem is that I do not seem to be able to format a cell to do " hh:mm:ss.t. "
>
> When I try, the date also appears and therefore screws up my calculations.
>
> Lewis.
>
> ***************************

Lewis,

Ignore the date/time display in the formula bar. Format the cell to display either hh:mm:ss or
mm:ss.t if you are concerned about tenths of a second. Make sure to enter zeros for hours (00:9:12)
if you are using minutes/seconds. You can write any formula using these values and Excel will be
able to calculate results.

If you want to see the decimal equivalent, Excel calculates time as a decimal portion of a day.
3:00:00 formatted as 'General' will display .125 or 1/8th of a day.

I have made a simple spreadsheet for marathon pacing that lets me enter a desired finish time (and
negative split if desired) and it will show a per
mile/km pace, (time/distance = pace). I then use that pace value (+/- neg split value if any) to
calculate checkpoint times for each mile/km. The results are formatted to be printed into a
wristband if I desire. There are lots of pace calculators and race predictors online but not
many for Excel that you can download and use offline.

Good luck,

Mike