Production Per Hour - Formulas In Excel - Microsoft Excel Tutorials

1.  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.

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.

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

Watch the Video Tutorial - https://www.youtube.com/watch?v=0H9elf-5EpI

Hope You Like This Tutorial - Give Comments