Question about Microsoft Excel for PC

# I am trying that works out average speed for a race. I enter the time (9mins 15sec) and excel tells me it is 9:15am. How do I get it to reconise the time as mins and secs not time of the day

Posted by on

• rbs6 Mar 11, 2009

Sorry my mistake( it was very late when I sent the Q ). I left out some important info. Car A takes 9min 15 secs to travel 19.24 kms.What is his average speed over that distance? I can work it out if I put the time in as 9.25mins. (I have a of list secs *1.6666666. ie 15 secs =.25 min ,33secs= .55min etc). I would rather not have to check my list, I would rather type 19.24 one cell and 9:15 in the next then do my calc from there. Thank for the previos answer, I sent the wrong info :-(

×

• Level 1:

An expert who has achieved level 1.

Problem Solver:

An expert who has answered 5 questions.

• Contributor

Hi there

I know how to solve this in your head it's a bit late but I've got the answer !!

9 mins and 15 secs = 9 1/4 mins
= Speed - distance divided by time = 19.24 / (9+1 / 4) = 2.08

If this is useful then I'm glad i could help :)

Posted on Oct 07, 2009

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that gotĀ 5 achievements.

Governor:

An expert whose answer gotĀ voted for 20 times.

Hot-Shot:

An expert who has answered 20 questions.

• Expert

Hi, here is the solution
1. Select column you want to put times.
2. Right click and select format.
3. go to Number tab and select custom
4. from custom list select h:mm:ss
Thats it
type the times in this format and apply average formula e.gl =AVERAGE(A1:A2:A3)

I will work, I just tested.

Posted on Mar 10, 2009

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### How we calculate piston rig gap

Under the average piston speed, we mean the average speed reached by the piston at certain revolutions. Average - because the piston for a single revolution of the crankshaft virtually stops twice, in the TDC (top dead centre) and BDC (bottom dead centre), to change the direction of movement from bottom to top and vice versa. The main part of the stress on the piston is on its pin: the rupture of the piston at excessive revolutions occurs at this critical point, which is what explains its strengthening.
The linear velocity of the piston is represented by the formula:
V = (C x g): 30
where V is the average speed of the piston, m / s,
C - stroke of the piston, m (stroke in 40 mm is 0,04 m)
g - speed of rotation (rotation), at which it is necessary to determine the average speed of the piston
30 is a fixed number
Studying some engines, including racing, we found interesting things.
The 50 cc engine for a scooter at 8000 rpm has an average piston speed of 10.6 m / s
The 100 cm engine for the ICA card at 21,000 rpm has an average piston speed of 35 m / s

May 24, 2018 | Cars & Trucks

### Average Handling Time for Emails

You only need one formula for this.
Total handling time divided by the total number of emails answered.

May 13, 2013 | Microsoft Excel for PC

### How to get the average of the velocity if motion is under constant acceleration

Take the example of a racing car as pictured in the animation above. It takes the vehicle 10 minutes(0.17 hours) to travel 23km, from start to finish.

Average speed = 23km / 0.17hrs = 135.29km/hr

Average velocity = 4km / 0.17hrs = 23.53km/hr

The average speed is 135.29km/hr but the velocity is only 23.53km/hr. The reason that velocity is lower, is that it can be positive and negative. Remember this from our earlier discussion on velocity? If not,click to refresh your memory. Since the velocity has negative and positive values some will cancel each other out, hence the lower value. Speed, however, can only be positive.

Jul 19, 2011 | Adobe Computers & Internet

### Hit Navigator key, takes a very long time 20+ min to find location.

There is a problem with your battery level. Make sure its fully charged. if it does not hold a charge when off the power for at least 2 hours then change it. 99.9% of the time low power delays connection to satellites. the max timke is about 9mins but average 1-2mins .....20 mins is not acceptable. I would suspect the battery.

DO NOT power the unit prior to starting the engine when using DC plug of car This will burn off the IC CHIP and damage your units battery.

Sep 02, 2009 | GPS

### 1998 olds A/C will only cool on the highway and at idle get warm? i have hooked up a gauge ti the low side and it reads about 100 psi. i have tried to add freon but it wont take. i cannot hear the clutch....

but on my view ur gas expires have u got reading when it pumped.after more than 2 year the gas is expires and doesnot coolling well.. as u says that at highway it cools when the engine get average race the compressor also race upon the engine and get compression right(at high speed) but at low average speed it not work because the gas doesnot compress properly due to gas expiry.....
check new gas......i think u r compressor is good enough if it cools at any time....if compressor dead then it doesnot coll at any time....because the compression valve varssuls are down at bottom......

i think my idea will healp u...good luck.

Aug 23, 2009 | Oldsmobile Aurora Cars & Trucks

### Wireless connection excellent / won't connect to internet

TRY TO CHECK YOUR CONFIGURATION... OR RE CONFIGURE AGAIN WITH THE CARDS.. MAKE IT SURE THE SETTING IS CORRECT. USERNAME AND PASSWORD YOU ENTERED.

May 26, 2009 | Trendware TEW-432BRP Wireless Router...

### Excel and the AVERAGE function

Here is one way:

In this example, my numbers are in cells a1 through a4. My average is computed with the formula:

=SUM(A1:A4)/COUNTIF(A1:A4,"<>0")

I'm summing the range of numbers and dividing that by the count of nonzero numbers. With this formula, you'll get an error if there are no nonzero numbers.

Dec 30, 2007 | Computers & Internet

### Excel

The Data Analysis Add-in has a Moving Average fuction and wizard. Moving Average

Aug 30, 2007 | Microsoft Office Standard for PC

#### Related Topics:

111 people viewed this question

Level 3 Expert

Level 3 Expert