Cycling and bicycle discussion forums. 
   Click here to join our community Log in to access your Control Panel  


Go Back   > >

"The 33"-Road Bike Racing We set this forum up for our members to discuss their experiences in either pro or amateur racing, whether they are the big races, or even the small backyard races. Don't forget to update all the members with your own race results.

User Tag List

Reply
 
Thread Tools Search this Thread
Old 04-02-07, 11:42 AM   #1
Rocket Richard
Guest
 
Bikes:
Posts: n/a
Mentioned: Post(s)
Tagged: Thread(s)
Quoted: Post(s)
TT Worksheet - Need XL formula help

I'm trying to make a working average speed calculator in Microsoft XL and I know some of you promoters out there have probably done this before. I just need to know how to manipulate the formula given distance and time (example 22 min. 25 sec and 10 miles). I know you have to convert all to seconds and I can figure it out manually, but I don't know how to make XL break down minutes and seconds to all seconds. Thanks in advance.
  Reply With Quote
Old 04-02-07, 12:10 PM   #2
Enthalpic
Killing Rabbits
 
Join Date: Apr 2005
Bikes:
Posts: 5,124
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 5 Post(s)
Change timestamps to number formating, then manipulate.

1day = 1
1hour = 1/24 = 0.0417
etc
Enthalpic is offline   Reply With Quote
Old 04-02-07, 12:33 PM   #3
Vinokurtov
Now Racer Ex
 
Vinokurtov's Avatar
 
Join Date: Jan 2006
Bikes:
Posts: 1,709
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Quote:
Originally Posted by Rocket Richard
I'm trying to make a working average speed calculator in Microsoft XL and I know some of you promoters out there have probably done this before. I just need to know how to manipulate the formula given distance and time (example 22 min. 25 sec and 10 miles). I know you have to convert all to seconds and I can figure it out manually, but I don't know how to make XL break down minutes and seconds to all seconds. Thanks in advance.
Rocket,

PM me an Email address and I'll forward my sheet to you.
Vinokurtov is offline   Reply With Quote
Old 04-02-07, 12:34 PM   #4
Enthalpic
Killing Rabbits
 
Join Date: Apr 2005
Bikes:
Posts: 5,124
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 5 Post(s)
Quote:
Originally Posted by Vinokurtov
Rocket,

PM me an Email address and I'll forward my sheet to you.
Give a man a fish and you feed him for a day..
Enthalpic is offline   Reply With Quote
Old 04-02-07, 01:12 PM   #5
waterrockets 
Making a kilometer blurry
 
waterrockets's Avatar
 
Join Date: May 2006
Location: Austin (near TX)
Bikes: rkwaki's porn collection
Posts: 26,130
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Quote:
Originally Posted by Enthalpic
Give a man a fish and you feed him for a day..
mmmm.... fish...
waterrockets is offline   Reply With Quote
Old 04-02-07, 01:36 PM   #6
Rocket Richard
Guest
 
Bikes:
Posts: n/a
Mentioned: Post(s)
Tagged: Thread(s)
Quoted: Post(s)
Quote:
Originally Posted by Vinokurtov
Rocket,

PM me an Email address and I'll forward my sheet to you.
OK; I will PM you; Thanks Vin.
  Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT -6. The time now is 05:37 PM.