Microsoft Excel Functions & Formulas

Production per hour

Data for some employees is recorded in a worksheet. They work a

varied number of hours each day to produce clocks. By calculating

the number of pieces each employee produces per hour, it can be

determined who is the most productive employee.

4

To see who is the most productive employee:

1. In a worksheet, enter your own data or the data shown in

Figure 1-1.

2. Select cells D2:D7.

3. Enter the following formula: =C2/(B2*24).

4. Press <Ctrl+Enter> to fill the selected cell range with

the current entry.

5. From the Format menu, select Cells.

6. Select the Number tab and then select Number from the

Category list.

7. Set Decimal places to 2