A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Calculation Problem



 
 
Thread Tools Display Modes
  #1  
Old April 15th, 2010, 09:36 PM posted to microsoft.public.excel.misc
Norm
external usenet poster
 
Posts: 149
Default Calculation Problem

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!!!
  #2  
Old April 15th, 2010, 10:04 PM posted to microsoft.public.excel.misc
dlw
external usenet poster
 
Posts: 1,600
Default Calculation Problem

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

  #3  
Old April 15th, 2010, 10:07 PM posted to microsoft.public.excel.misc
Russell Dawson[_2_]
external usenet poster
 
Posts: 173
Default Calculation Problem

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

  #4  
Old April 15th, 2010, 10:13 PM posted to microsoft.public.excel.misc
Norm
external usenet poster
 
Posts: 149
Default Calculation Problem

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

  #5  
Old April 15th, 2010, 10:42 PM posted to microsoft.public.excel.misc
Norm
external usenet poster
 
Posts: 149
Default Calculation Problem

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

  #6  
Old April 16th, 2010, 04:37 AM posted to microsoft.public.excel.misc
Russell Dawson[_2_]
external usenet poster
 
Posts: 173
Default Calculation Problem

=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!!!

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:26 PM.


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