TT Worksheet - Need XL formula help
04-02-07, 11:42 AM
#1
Guest
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:33 PM
#3
Now Racer Ex
Join Date: Jan 2006
Posts: 1,709
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
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.
PM me an Email address and I'll forward my sheet to you.
04-02-07, 12:34 PM
#4
Killing Rabbits
Join Date: Apr 2005
Posts: 5,697
Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 278 Post(s)
Liked 217 Times
in
102 Posts
Originally Posted by Vinokurtov
Rocket,
PM me an Email address and I'll forward my sheet to you.
PM me an Email address and I'll forward my sheet to you.
04-02-07, 01:12 PM
#5
Making a kilometer blurry
Originally Posted by Enthalpic
Give a man a fish and you feed him for a day..
