Bike Forums > TT Worksheet - Need XL formula help
 Register All Albums Elite Membership Forum Rules Calendar Search Today's Posts Mark Forums Read

 "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.

 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.
 04-02-07, 12:10 PM #2 Enthalpic Killing Rabbits   Join Date: Apr 2005 Bikes: Posts: 5,231 Mentioned: 0 Post(s) Tagged: 0 Thread(s) Quoted: 64 Post(s) Change timestamps to number formating, then manipulate. 1day = 1 1hour = 1/24 = 0.0417 etc
04-02-07, 12:33 PM   #3
Vinokurtov
Now Racer Ex

Join Date: Jan 2006
Bikes:
Posts: 1,709
Mentioned: 0 Post(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.

04-02-07, 12:34 PM   #4
Enthalpic
Killing Rabbits

Join Date: Apr 2005
Bikes:
Posts: 5,231
Mentioned: 0 Post(s)
Quoted: 64 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..

04-02-07, 01:12 PM   #5
waterrockets
Making a kilometer blurry

Join Date: May 2006
Location: Austin (near TX)
Bikes: rkwaki's porn collection
Posts: 26,130
Mentioned: 2 Post(s)
Quoted: 2 Post(s)
Quote:
 Originally Posted by Enthalpic Give a man a fish and you feed him for a day..
mmmm.... fish...

04-02-07, 01:36 PM   #6
Rocket Richard
Guest

Bikes:
Posts: n/a
Mentioned: Post(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.