software

What is the corecct / simple formular to calculate the average speed?
In one colum I enter the distance (miles) traveled.
The other colum I enter the time. Time format is quot;hh:mmquot;

What I would like is to have the third colum look at both of these columns
and based on a formular?? display the average speed.

I have attempted this by trying the quot;CONVERTquot; function to convert the time
entered to all minutes but for some reason it does not work correctly??

For example the time entered is 3:05 which is 185 minutes.
When I use the quot;CONVERTquot; function it comes out as 183 ???
Is the problem with the time format that I'm using?


41db14 Wrote:
gt; What is the corecct / simple formular to calculate the average speed?
gt; In one colum I enter the distance (miles) traveled.
gt; The other colum I enter the time. Time format is quot;hh:mmquot;
gt;
gt; What I would like is to have the third colum look at both of these
gt; columns
gt; and based on a formular?? display the average speed.
gt;
gt; I have attempted this by trying the quot;CONVERTquot; function to convert the
gt; time
gt; entered to all minutes but for some reason it does not work
gt; correctly??
gt;
gt; For example the time entered is 3:05 which is 185 minutes.
gt; When I use the quot;CONVERTquot; function it comes out as 183 ???
gt; Is the problem with the time format that I'm using?
Try this...assume A1~C1 are Mile, Time, and Speed respectively. Make
sure time is input in text format so the formula bar displays quot;3:05quot;
not quot;3:05:00 AMquot;.

C2 =
A2/(CONVERT(LEFT(B2,FIND(quot;:quot;,B2)-1),quot;hrquot;,quot;mnquot;) RIGHT(B2,LEN(B2)-FIND(quot;:quot;,B2)))--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: www.excelforum.com/member.php...foamp;userid=7094
View this thread: www.excelforum.com/showthread...hreadid=522723
quot;41db14quot; gt; wrote in message
...
gt; What is the corecct / simple formular to calculate the average speed?
gt; In one colum I enter the distance (miles) traveled.
gt; The other colum I enter the time. Time format is quot;hh:mmquot;
gt;
gt; What I would like is to have the third colum look at both of these columns
gt; and based on a formular?? display the average speed.
gt;
gt; I have attempted this by trying the quot;CONVERTquot; function to convert the time
gt; entered to all minutes but for some reason it does not work correctly??
gt;
gt; For example the time entered is 3:05 which is 185 minutes.
gt; When I use the quot;CONVERTquot; function it comes out as 183 ???
gt; Is the problem with the time format that I'm using?

Format time cell as [h]:mm:ss
Avg Speed is distance over time, so
If A1 is time, and B1 is distance, C1 is
=B1/(A1*24)

Beege
quot;Beegequot; gt; wrote in message
...
gt;
gt; quot;41db14quot; gt; wrote in message
gt; ...
gt;gt; What is the corecct / simple formular to calculate the average speed?
gt;gt; In one colum I enter the distance (miles) traveled.
gt;gt; The other colum I enter the time. Time format is quot;hh:mmquot;
gt;gt;
gt;gt; What I would like is to have the third colum look at both of these
gt;gt; columns
gt;gt; and based on a formular?? display the average speed.
gt;gt;
gt;gt; I have attempted this by trying the quot;CONVERTquot; function to convert the
gt;gt; time
gt;gt; entered to all minutes but for some reason it does not work correctly??
gt;gt;
gt;gt; For example the time entered is 3:05 which is 185 minutes.
gt;gt; When I use the quot;CONVERTquot; function it comes out as 183 ???
gt;gt; Is the problem with the time format that I'm using?
gt;
gt; Format time cell as [h]:mm:ss
gt; Avg Speed is distance over time, so
gt; If A1 is time, and B1 is distance, C1 is
gt; =B1/(A1*24)
gt;
gt; Beege

And converting Hours to Minutes is
=A1*1440

Beege