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

CALCULATE THE AGE OF A PERSON IN DAYS

A worksheet lists the names of friends in column A and their birth dates in column B. To calculate the number of days each person has been alive, enter the current date in cell B1 and perform the following steps:

To calculate the age of a person in days:

1. In a worksheet, enter your own data or the data shown in Figure 1-2.
2. Select cells C5:C9.
3. Enter the following formula: =$B$1-B5.
4. Press <-Ctrl+Enter-> .
5. From the Format menu, select Cells.
6. Select the Number tab and then select General from the Category list.
7. Click OK.

CALCULATE THE AGE OF A PERSON IN DAYS - MICROSOFT EXCEL TUTORIALS

Watch the Video Tutorial



Microsoft Excel Tutorials,  Simple Formula, Basic Tutorial, Formulas In Excel, Microsoft Excel Video Tutorials