Calculation Problem - microsoft.public.excel.misc

I want to calculate production numbers I have the standard number in G2 I have the actual production number in F5 I have the time duration in I5 I need the average per hour in J5 Can someone help please If more info is required please let me know Cheers!!!

if the time duration in I5 is in hours, in J5 enter this: =F5/I5 "Norm" wrote: > I want to calculate production numbers > I have the standard number in G2 > I have the actual production number in F5 > I have the time duration in I5 > I need the average per hour in J5 > Can someone help please > If more info is required please let me know > Cheers!!!

The average per hour would be F5/I5 but where does the "standard number" in G2 come in. What is it? How does it effect your calculation? -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Norm" wrote: > I want to calculate production numbers > I have the standard number in G2 > I have the actual production number in F5 > I have the time duration in I5 > I need the average per hour in J5 > Can someone help please > If more info is required please let me know > Cheers!!!

I had production of 37 pieces done in 37 minutes I need to know what that equals in 60 min I can not get J5 to show 60 pieces per hour F5 is a number and I5 is time Thank you for your help "dlw" wrote: > if the time duration in I5 is in hours, in J5 enter this: > =F5/I5 > > "Norm" wrote: > > > I want to calculate production numbers > > I have the standard number in G2 > > I have the actual production number in F5 > > I have the time duration in I5 > > I need the average per hour in J5 > > Can someone help please > > If more info is required please let me know > > Cheers!!!

I had thought the the per hour target (in G2) would come into the calculation When I use F5/I5 I get 1465 per hour which does not work if I had 37 pieces done in 37 minutes "Russell Dawson" wrote: > The average per hour would be F5/I5 but where does the "standard number" in > G2 come in. What is it? How does it effect your calculation? > -- > Russell Dawson > Excel Student > > Please hit "Yes" if this post was helpful. > > > "Norm" wrote: > > > I want to calculate production numbers > > I have the standard number in G2 > > I have the actual production number in F5 > > I have the time duration in I5 > > I need the average per hour in J5 > > Can someone help please > > If more info is required please let me know > > Cheers!!!

=F5/I5*60 Duration is in minutes -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Norm" wrote: > I had thought the the per hour target (in G2) would come into the calculation > When I use F5/I5 I get 1465 per hour which does not work if I had 37 pieces > done in 37 minutes > > "Russell Dawson" wrote: > > > The average per hour would be F5/I5 but where does the "standard number" in > > G2 come in. What is it? How does it effect your calculation? > > -- > > Russell Dawson > > Excel Student > > > > Please hit "Yes" if this post was helpful. > > > > > > "Norm" wrote: > > > > > I want to calculate production numbers > > > I have the standard number in G2 > > > I have the actual production number in F5 > > > I have the time duration in I5 > > > I need the average per hour in J5 > > > Can someone help please > > > If more info is required please let me know > > > Cheers!!!

Similiar Articles:

Cost calculation problem - microsoft.public.project
I have a problem with how MS Project is calculating the annual cost for a resource. For example, if I have a resource with a Std. Rate of $1,000 pe...

Advance Payroll - Overtime Calculation Method Setup Problem ...
We use the Overtime Calculations in Advenced Payroll. The problem is when we set up a new employee and assign them to a class, the OT paycode gets s...

Total Cost Calculation for MS Project 2007 - microsoft.public ...
Good Afternoon, Here is the scenario/problem: I have created a task (100 days duration) and assigned 2 resources to the task at a straight ti...

Excel 2007 will not refresh cells - microsoft.public.excel ...
Excel 2007 automatic calculation problem? Why Excel web query sometimes does not refresh? Will excel update cell references when adding cells from a…

Storing calculated fields - microsoft.public.access.forms ...
Having the calculation result appear in the form is not a problem. The problem is the field control cannot be assigned to the table AND be the result of a calculation ...

How do I calculate escalation rates using dates and a set value ...
Cost calculation problem - microsoft.public.project... if I have a resource with a Std. Rate ... by the minute based on the options set ... you say Bob is $1,000 a month ...

calculating average days - microsoft.public.access.queries ...
Cost calculation problem - microsoft.public.project I have a problem with how MS Project is calculating the annual cost for a resource. ... Average Days to Pay - microsoft ...

calculating incremental value contingent on other field ...
Cost calculation problem - microsoft.public.project I have a problem with how MS Project is calculating the annual cost ... calculating incremental value contingent on ...

Smartlist Builder Permission Problems - microsoft.public ...
Cost calculation problem - microsoft.public.project Smartlist builder calculated field problem DataBase I am trying to build a ... ... Smartlist Builder Permission ...

SmartList Builder Calculation - microsoft.public.greatplains ...
Cost calculation problem - microsoft.public.project SmartList Builder Calculation - microsoft.public.greatplains ... I created a calculation for Percent of Cost.

Economic calculation problem - Wikipedia, the free encyclopedia
The economic calculation problem is a criticism of central economic planning. It was first proposed by Ludwig von Mises in 1920 and later expounded by Friedrich Hayek.

Talk:Economic calculation problem - Wikipedia, the free encyclopedia
The change on November 4, 2005 was me. (I don't have a Wikipedia account yet but this is my internet moniker ;))

Economic calculation problem - Definition | WordIQ.com
Liberal thinkers. Many liberal thinkers, especially those of the Austrian School believed Marxist economics to be impractical because it denied private ownership of ...

XXVI. THE IMPOSSIBILITY OF ECONOMIC CALCULATION UNDER SOCIALISM ...
XXVI. THE IMPOSSIBILITY OF ECONOMIC CALCULATION UNDER SOCIALISM 1. The Problem . The director wants to build a house. Now, there are many methods ...

Calculation Problem
First, I have 2 values ( 4807.4 , 4245.8 ), and the first value is come from a variable, another one is come from a text box, what I want to do in VB.NET ...

7/17/2012 12:47:16 PM