How to calculate productivity in time basis
Requirement:
The user needs a formula to calculate total units for one hour.
| Min Per hour | Process time | Wafers | Unit Per Hour |
| 60 | 0:36:00 | 25 | |
| 60 | 0:15:00 | 25 | |
| 60 | 1:00:00 | 25 |
Solution:
Try this...
|
A
|
B
|
C
|
D
|
E
|
|
|
1
|
Min Per hour | Process time | Wafers | Unit Per Hour | |
|
2
|
60 | 0:36:00 | 25 | 3.6 |
41.66667
|
|
3
|
60 | 0:15:00 | 25 |
100
|
|
|
4
|
60 | 1:00:00 | 25 |
25
|
D2=1/24/B2*C2
Obtained from the OzGrid Help Forum.
Solution provided by FDibbins.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to delete row if Date/Time between 05:00 - 20:00 |
| How to copy data in VBA from different named workbook each time |
| How to copy 300 rows at a time from one column with 3K rows and convert to csv file |
| How to set a countdown timer to beep under 10 seconds |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
