# Calculate productivity in time basis

• Need formula to calculate total units for one hour.

[TABLE="width: 396"]

[tr]

[td]

Min Per hour

[/td]

[td]

Process time

[/td]

[td]

Wafers

[/td]

[td]

Unit Per Hour

[/td]

[/tr]

[tr]

[td]

60

[/td]

[td]

0:36:00

[/td]

[td]

25

[/td]

[td][/td]

[/tr]

[tr]

[td]

60

[/td]

[td]

0:15:00

[/td]

[td]

25

[/td]

[td][/td]

[/tr]

[tr]

[td]

60

[/td]

[td]

1:00:00

[/td]

[td]

25

[/td]

[/tr]

[/TABLE]

• Re: Calculate productivity in time basis

Try this...
[Table="width:, class:grid"]

[tr][td]

[/td][td]

A

[/td][td]

B

[/td][td]

C

[/td][td]

D

[/td][td]

E

[/td][/tr]

[tr][td]

1

[/td][td]

Min Per hour

[/td][td]

Process time

[/td][td]

Wafers

[/td][td]

Unit Per Hour

[/td][td]

[/td][/tr]

[tr][td]

2

[/td][td]

60

[/td][td]

0:36:00

[/td][td]

25

[/td][td]

3.6

[/td][td]

41.66667

[/td][/tr]

[tr][td]

3

[/td][td]

60

[/td][td]

0:15:00

[/td][td]

25

[/td][td]

[/td][td]

100

[/td][/tr]

[tr][td]

4

[/td][td]

60

[/td][td]

1:00:00

[/td][td]

25

[/td][td]

[/td][td]

25

[/td][/tr]

[/table]

D2=1/24/B2*C2
copied down

Regards

Ford

• Re: Calculate productivity in time basis

Hi,
Yes, this is what I want.
Thank you.

• Re: Calculate productivity in time basis

Glad to help

Regards

Ford

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!