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,
a 6ya expert can help you resolve that 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.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

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

### Instructions

This si a mini guide I hope it helps...please rate me ...thanks ....The Fang

Career Guide
Settings
Use the 12 race schedule and turn Yellow Flags ON. You can advance quicker with the shorter length season and the Yellow Flags often give you a break by allowing you to catch up for the restart.

Startup
• Sponsors: Don't take the hardest (best paying) sponsorships right away. You're only paid if you actually meet those expectations.
• Team: For now, go with the cheapest talent available. If costs are equal, go with a pit crew guy with the better speed rating. You should also keep an eye out for a good potential rating

The way to bigger and better sponsorship is to raise Sponsor Prestige. When it reaches 60, you will get tougher and more lucrative offers. Hopefully, you will also have a good enough car to achieve these new goals.
• Expectations and Income: This tells you what the sponsor wants from you and how much they will pay you when you meet their standards.
• Prestige: Prestige is a measure of how respected this sponsor is in the world of NASCAR. Typically, a sponsor with higher prestige will have more difficult expectations and better income. Prestige changes depending upon your race finish. The better you finish, the more likely that sponsor's prestige will go up. You will receive a bonus payout anytime a sponsor's prestige reaches a new all-time high. Also, when a sponsor's prestige reaches the next level (60, 70, 80, 90), new offers will become available from sponsors in that location. These new offers will have more difficult expectations, but significantly better income.
• Happiness: Happiness is a measure of how your sponsor feels about your performance. This is based primarily on whether or not you meet their expectations. When a sponsor's happiness is above 70, you will receive bonus income.

Team
In the early going, especially when you don't really need to build new equipment, go with the cheapest Builders. This will help keep costs down and maximize your income.
Your Team is broken down into 2 types: Builders and Pit Crew. The average ratings of your Pit Crew determine the quality of your stops. Their average speed will determine overall how quick your stops will be. Their average skill will determine the likelihood of pit crew fumbles. Overall, speed is probably more valuable than skill.
Your Builder's ratings are used in the construction of new equipment.
A crew's Happiness is very important. A crew member will perform at his indicated rating when his Happiness is at 75. When it is less than that, their actual performance is up to 15% lower (Happiness of 50). The reverse is also true: Happiness of 100 will give 15% better performance than the indicated rating.
The Happiness is dependent upon your race finishes. Each crew member has an expected finish that is based upon his average rating. When you do better than expected, their happiness will increase.
R&D
This is perhaps the most important aspect of your operation. You need to invest in R&D early and often in order to improve your cars' performance. Each level of R&D equates to an increase of 10 in the base value of that rating. For example in the beginning, your R&D level of Engine Power is 0. Your base rating for Engine Power on new equipment is 50. When you finish R&D on Engine Power 1, the base rating will be 60.
This base rating is averaged with your Builder's rating (adjusted by Happiness) to determine how good that piece of equipment will be. In the above example with Eng. Power of 1 and an Engine Builder with a Power rating of 66 (and Happiness of 75), any new engine you build would have a Power rating of about 63.
So, after you finish your first piece of R&D, go to your Team Builders menu and fire the guy with the same rating as the R&D you just finished. So, if you've finished Eng. Power, fire your Engine Builder and get a new one who has ratings in the 60's. This new Builder will be able to take full advantage of the latest R&D.

Garage
This is the most complex area of your operation, although not at first. As your equipment improves, you'll want to visit this area often to make sure your equipment is in good Condition. For every 2 points of Condition loss, your car will lose 1 point off of its ratings down to a minimum value of 50. Condition loss depends on how much you abuse your car during a race.
But since the difference between a 53 and a 50 isn't that much, you shouldn't worry about repairing your equipment until you build your first new engine or chassis. This will save you some cash.
Once you do finally build something new, you'll need to start monitoring its Condition and repairing as necessary. Overhauling will increase an older piece of equipment's ratings utilizing your latest level of R&D. However, until you have several levels of R&D in each area, it's usually more cost effective to just Build new equipment.

General Racing
Practice each track before you qualify/race. Your car handles very differently than it does in Quick Race. You can also make some fairly easy tweaks to your Car Setup that will greatly increase your lap times in the early races of career. You'll probably want to increase the wedge setting a bit to tighten the car (so it isn't so skid happy). But the single biggest improvement you can make is to your Gear Ratio. Adjust 4th gear until you are maxing out at 9000 RPM at the end of the straightaways. Going any higher than 9000 could damage your engine.
ALWAYS qualify for the race. Not only are at least one of your Sponsor expectations based on qualifying, but starting as close to the front as you can will help your race finishes.
Be patient and take what the track and other racers will give you. Remember that at the beginning of a career, you're not competing for the win. Set your sights on finishing 40th and run a race that will get you there. Don't be overly aggressive; if you lose control and crash with yellow flags OFF, you won't be able to recover for a good finish.
In the early going, you're pit crew is not very good, and you will lose some time in the pits. You can overcome this with some pit strategy (2 tire stops on low tire wear tracks like Daytona) or by just trying to gain as many spots as you can before the mid-race pit stop.
Here's a guideline to how you should be qualifying and finishing depending upon the average rating of your car:
50: ~40th
60: ~30th
70: ~20th
80: ~10th
90: ~1st
These are for Veteran difficulty with a player who can usually finish in the Top 5 in Quick Race. Rookie mode is significantly easier.

Secrets
Unlock Tiburon Speedway
If you have a save from any 2003 EA Sports game on your hard drive or memory card, the Tiburon Speedway track will be automatically unlocked.
Unlock Fantasy Drivers
Enter Extra Drivers as the Create-a-Car neame to unlock all fantasy drivers.

Mar 25, 2009 | EA Sports Video Game Consoles & Games

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

## Open Questions:

#### Related Topics:

109 people viewed this question

Level 3 Expert

Level 3 Expert