Need formula to calculate total units for one hour.
[TABLE="width: 396"]
Min Per hour
[/td]Process time
[/td]Wafers
[/td]Unit Per Hour
[/td]60
[/td]0:36:00
[/td]25
[/td]60
[/td]0:15:00
[/td]25
[/td]60
[/td]1:00:00
[/td]25
[/td]
[/TABLE]
Need formula to calculate total units for one hour.
[TABLE="width: 396"]
Min Per hour
[/td]Process time
[/td]Wafers
[/td]Unit Per Hour
[/td]60
[/td]0:36:00
[/td]25
[/td]60
[/td]0:15:00
[/td]25
[/td]60
[/td]1:00:00
[/td]25
[/td]
[/TABLE]
Re: Calculate productivity in time basis
Explain your logic if you were to do this manually with pen and paper.
Re: Calculate productivity in time basis
Try this...
[Table="width:, class:grid"]
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
[/table]
D2=1/24/B2*C2
copied down
Re: Calculate productivity in time basis
Hi,
Yes, this is what I want.
Thank you.
Re: Calculate productivity in time basis
Glad to help
Don’t have an account yet? Register yourself now and be a part of our community!