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