Help with training log.

Lewis Campbell <[email hidden]> 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

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

blarg.netrunlog.htmlOpen ↗

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

Larry McMahan <[email hidden]> wrote in message news:<[email hidden]>...

Quoted message said:

Lewis Campbell <[email hidden]> 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.

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

"David Hallsworth" <[email hidden]> wrote in message news:<[email hidden]>...

Quoted message said:

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

blarg.netrunlog.htmlOpen ↗

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.

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

"Lewis Campbell" <[email hidden]> wrote in message
"]news:[email hidden]...

Quoted message said:

Larry McMahan <[email hidden]> wrote in message

news:<[email hidden]>...

Quoted message said:

Quoted message said:

Lewis Campbell <[email hidden]> 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