# "The 33"-Road Bike Racing - TT Worksheet - Need XL formula help

Bikeforums.net is a forum about nothing but bikes. Our community can help you find information about hard-to-find and localized information like bicycle tours, specialties like where in your area to have your recumbent bike serviced, or what are the best bicycle tires and seats for the activities you use your bike for.

Rocket Richard
04-02-07, 11:42 AM
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.

Enthalpic
04-02-07, 12:10 PM
Change timestamps to number formating, then manipulate.

1day = 1
1hour = 1/24 = 0.0417
etc

Vinokurtov
04-02-07, 12:33 PM
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.

Enthalpic
04-02-07, 12:34 PM
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..

waterrockets
04-02-07, 01:12 PM
Give a man a fish and you feed him for a day..

mmmm.... fish...
http://www.realbeer.com/edu/images/homer.jpg

Rocket Richard
04-02-07, 01:36 PM
Rocket,

PM me an Email address and I'll forward my sheet to you.

OK; I will PM you; Thanks Vin.