| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula to calucalte part per hour?
I am working on a spread sheet where I have to determined the amont if parts
made per hour. The formula I need is a 12 hour work day, minus the down time minutes to = parts per hour made. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formula to calucalte part per hour?
720 in A1
Downtime minutes in A2:A7 Number of parts in B1 In C1 =B1/((A1-SUM(A2:A7))/60) Gord Dibben MS Excel MVP On Tue, 6 May 2008 11:24:00 -0700, LaQaunda wrote: I am working on a spread sheet where I have to determined the amont if parts made per hour. The formula I need is a 12 hour work day, minus the down time minutes to = parts per hour made. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formula to calucalte part per hour?
thank i will try it
"Gord Dibben" wrote: 720 in A1 Downtime minutes in A2:A7 Number of parts in B1 In C1 =B1/((A1-SUM(A2:A7))/60) Gord Dibben MS Excel MVP On Tue, 6 May 2008 11:24:00 -0700, LaQaunda wrote: I am working on a spread sheet where I have to determined the amont if parts made per hour. The formula I need is a 12 hour work day, minus the down time minutes to = parts per hour made. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formula to calucalte part per hour?
i tried it and it did not work, I do not have columns for the down time
minutes. Do I need to add a column? or does this represent two seperate columns? "Gord Dibben" wrote: 720 in A1 Downtime minutes in A2:A7 Number of parts in B1 In C1 =B1/((A1-SUM(A2:A7))/60) Gord Dibben MS Excel MVP On Tue, 6 May 2008 11:24:00 -0700, LaQaunda wrote: I am working on a spread sheet where I have to determined the amont if parts made per hour. The formula I need is a 12 hour work day, minus the down time minutes to = parts per hour made. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formula to calucalte part per hour?
How do you figure down time minutes?
In article , LaQaunda wrote: i tried it and it did not work, I do not have columns for the down time minutes. Do I need to add a column? or does this represent two seperate columns? |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formula to calucalte part per hour?
How do you compute downtime minutes and where would they be stored?
My example used A2:A7 to keep track of downtime minutes then I subtracted those from the 12 hour shift(720 minutes). Gord On Wed, 7 May 2008 05:44:01 -0700, LaQaunda wrote: i tried it and it did not work, I do not have columns for the down time minutes. Do I need to add a column? or does this represent two seperate columns? "Gord Dibben" wrote: 720 in A1 Downtime minutes in A2:A7 Number of parts in B1 In C1 =B1/((A1-SUM(A2:A7))/60) Gord Dibben MS Excel MVP On Tue, 6 May 2008 11:24:00 -0700, LaQaunda wrote: I am working on a spread sheet where I have to determined the amont if parts made per hour. The formula I need is a 12 hour work day, minus the down time minutes to = parts per hour made. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up a formula for parts (or units) per hour? | Excel Worksheet Functions | |||
| convert decimal numbers to a fraction of an hour for payroll hour | Excel Worksheet Functions | |||
| Formula for Hour Minute and Second | Excel Worksheet Functions | |||
| driver hour compliance formula mto | Excel Discussion (Misc queries) | |||
| How can I round an hour to the nearest 1/4 hour? | Excel Worksheet Functions | |||
Hybrid Mode
