Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default HOW TO CALCULATE SPEED IF A CAR TRAVELS 600KM IN 4 HRS CARRYING 6.

i need to calculate the speed of a car if it is travelling with a weight of a
passenger at 60kg and the car travels a distance of 600km in 4.30hrs.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 367
Default HOW TO CALCULATE SPEED IF A CAR TRAVELS 600KM IN 4 HRS CARRYING 6.

On Nov 7, 3:48 pm, shabs wrote:
i need to calculate the speed of a car if it is travelling with a weight of a
passenger at 60kg and the car travels a distance of 600km in 4.30hrs.


Are you for real?

if yes:
The weight doesn't matter, unless you want to calculate how much gas
he uses.

the speed is: distance / time
600 km / 4.5h = 133 1/3 km/h

hth

Carlo

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default HOW TO CALCULATE SPEED IF A CAR TRAVELS 600KM IN 4 HRS CARRYIN

tks Carlo

I guess i did not mention gas...sorry

It is a project i am trying to help my son with. IF THERE IS MORE PAssengers
then i am sure the gas will make the diff. what will the formula then be ??
use yoyr own discretion regarding the amount of fuel used.
tks
shabs

"carlo" wrote:

On Nov 7, 3:48 pm, shabs wrote:
i need to calculate the speed of a car if it is travelling with a weight of a
passenger at 60kg and the car travels a distance of 600km in 4.30hrs.


Are you for real?

if yes:
The weight doesn't matter, unless you want to calculate how much gas
he uses.

the speed is: distance / time
600 km / 4.5h = 133 1/3 km/h

hth

Carlo


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 367
Default HOW TO CALCULATE SPEED IF A CAR TRAVELS 600KM IN 4 HRS CARRYIN

On Nov 7, 5:03 pm, shabs wrote:
tks Carlo

I guess i did not mention gas...sorry

It is a project i am trying to help my son with. IF THERE IS MORE PAssengers
then i am sure the gas will make the diff. what will the formula then be ??
use yoyr own discretion regarding the amount of fuel used.
tks
shabs



"carlo" wrote:
On Nov 7, 3:48 pm, shabs wrote:
i need to calculate the speed of a car if it is travelling with a weight of a
passenger at 60kg and the car travels a distance of 600km in 4.30hrs.


Are you for real?


if yes:
The weight doesn't matter, unless you want to calculate how much gas
he uses.


the speed is: distance / time
600 km / 4.5h = 133 1/3 km/h


hth


Carlo- Hide quoted text -


- Show quoted text -


Hi shabs

i think, that there is too many information missing.

If you want to know how fast he is, it does not matter how many
passengers there are.
If you want to do 600km in 4.5h, you always have to drive with 133 1/3
km/h (average speed)
it doesn't matter if you have 8 people in the car, or if you ride on a
horse.

You need to give us a little bit more information.
(How old is your son? Just to make sure, that we're not going over the
top with this :) )

Carlo

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,365
Default HOW TO CALCULATE SPEED IF A CAR TRAVELS 600KM IN 4 HRS CARRYIN

The speed of the car is only based on miles traveled and time to travel. 600
KM in 4.3 Hours is
600/4.3 = 139.5349 KM/Hr

Neither the weight of the load nor the amount of fuel used plays into speed,
not directly.

Quite often in 'word questions' information is given, such as the weight of
the passengers, that is NOT needed to solve the problem. This is included to
see if the student can pick out the pieces that ARE needed from among a lot
of information. So the fact that there was 60Kg of passengers might have
been mentioned just to see if you and he would ignore it or get confused by
it being there.

Also, be sure that it is 4.3 hours (4 hours 20 minutes) and not 4 hours and
30 minutes (4.5 hours). At 4.5 hours the speed would be
600/4.5 = 133.3333 KM/Hr



"shabs" wrote:

tks Carlo

I guess i did not mention gas...sorry

It is a project i am trying to help my son with. IF THERE IS MORE PAssengers
then i am sure the gas will make the diff. what will the formula then be ??
use yoyr own discretion regarding the amount of fuel used.
tks
shabs

"carlo" wrote:

On Nov 7, 3:48 pm, shabs wrote:
i need to calculate the speed of a car if it is travelling with a weight of a
passenger at 60kg and the car travels a distance of 600km in 4.30hrs.


Are you for real?

if yes:
The weight doesn't matter, unless you want to calculate how much gas
he uses.

the speed is: distance / time
600 km / 4.5h = 133 1/3 km/h

hth

Carlo




  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default HOW TO CALCULATE SPEED IF A CAR TRAVELS 600KM IN 4 HRS CARRYIN

That's one damn fast horse<g


Gord Dibben MS Excel MVP

On Wed, 07 Nov 2007 08:09:48 -0000, carlo wrote:

If you want to do 600km in 4.5h, you always have to drive with 133 1/3
km/h (average speed)
it doesn't matter if you have 8 people in the car, or if you ride on a
horse.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate average speed britgrit Excel Discussion (Misc queries) 3 May 29th 07 07:26 PM
Calculate average speed 41db14 Excel Worksheet Functions 3 March 15th 06 06:52 PM
Can you speed UP drag speed? Ryan W Excel Discussion (Misc queries) 1 October 24th 05 06:09 PM
How to calculate speed given distance and mm:ss time format? rrl Excel Discussion (Misc queries) 1 October 21st 05 05:39 PM
Carrying formatting automatically to new W/S Jonah Excel Worksheet Functions 4 September 6th 05 12:12 AM


All times are GMT +1. The time now is 07:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"