Calculation help
in [General]
|
From: Norm on 15 Apr 2010 18:41 I want to calculate production numbers I have the actual production number in F5 (115 peices) I have the time duration in I5 (:59) I need the average per hour in J5 Can someone help please If more info is required please let me know Cheers!!!
From: Bob Phillips on 15 Apr 2010 18:52 Try =F5/(I5*24) -- HTH Bob "Norm" <Norm(a)discussions.microsoft.com> wrote in message news:36292C5A-3EDD-40DF-9885-F763F352FD68(a)microsoft.com... >I want to calculate production numbers > I have the actual production number in F5 (115 peices) > I have the time duration in I5 (:59) > I need the average per hour in J5 > Can someone help please > If more info is required please let me know > Cheers!!! >
From: Roger Govier on 15 Apr 2010 18:55 Hi Norm Time is stored as fractions of a day (24 hours). So =F5/(I5*24) Format J5 as General Result is 116.95 -- Regards Roger Govier Norm wrote: > I want to calculate production numbers > I have the actual production number in F5 (115 peices) > I have the time duration in I5 (:59) > I need the average per hour in J5 > Can someone help please > If more info is required please let me know > Cheers!!! >
From: Dianne on 15 Apr 2010 19:05 Norm;700670 Wrote: > I want to calculate production numbers > I have the actual production number in F5 (115 peices) > I have the time duration in I5 (:59) > I need the average per hour in J5 > Can someone help please > If more info is required please let me know > Cheers!!! Be sure F5 is number format, I5 is time format, J5 is h:ss and enter this formula: =AVERAGE(F5*59/60) -- Dianne ------------------------------------------------------------------------ Dianne's Profile: http://www.thecodecage.com/forumz/member.php?u=1755 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=196041 http://www.thecodecage.com/forumz
|
Pages: 1 Prev: Excel - Expense tracking-multiple users Next: Excel 2007 missing data using auto filter |