PRODUCTION PER HOUR USING EXCEL FORMULAS

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.

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.

PRODUCTION PER HOUR USING EXCEL FORMULAS

Mr. Beckham is the most productive. He produces an average of nearly 22 clocks per hour.

Watch the Video Tutorial



Microsoft Excel Tutorials, Microsoft Excel Video Tutorials, Excel Tutorials using Macro, Formulas in Excel