Question about Microsoft Excel for PC

2 Answers

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 :-(



2 Answers

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 5 Answers

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


    An expert that gotĀ 5 achievements.


    An expert whose answer gotĀ voted for 20 times.


    An expert who has answered 20 questions.

  • Expert
  • 189 Answers

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 =AVERAGE(A1:A2:A3)

I will work, I just tested.

Posted on Mar 10, 2009


1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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

Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

1 Answer

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

1 Answer

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

1 Answer

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

1 Answer

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

1 Answer

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....

ur gass reading is good....
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

1 Answer

Wireless connection excellent / won't connect to internet


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

2 Answers

USB Dvice not reconised @ Web is not working

Have you tried pluging it into a different USB port.

May 31, 2008 | Umax AstraPix PC200 Webcam

1 Answer

Ps2 - certain games do not play

please just tell me how it works..............

May 30, 2008 | Sony PlayStation 2 Slimline Console

1 Answer

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:


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

1 Answer


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

Aug 30, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

111 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

3007 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Alun Cox

Level 3 Expert

2678 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides