Calculate the totals as follows:
In cell E15, enter a formula using the SUM function to total the actual hours (range E5:E14).
b. Use the Fill Handle to fill the range F15:15 with the formula in cell E15.
Apply the Accounting number format with no decimal places to the range F15:H15
To calculate the actual hours and fill the range with the formula, and format the range as described, follow these steps:
1. In cell E15, enter the formula using the SUM function to total the actual hours: `=SUM(E5:E14)`. This formula will add up the values in the range E5:E14 and display the total in cell E15.
2. Select cell E15 and click on the Fill Handle (a small square at the bottom-right corner of the cell). Drag the Fill Handle across to the range F15:H15. This will copy the formula from cell E15 to the adjacent cells in the range F15:H15.
3. To format the range F15:H15 in the Accounting number format with no decimal places, select the range F15:H15.
4. Right-click on the selected range and choose "Format Cells" from the context menu. Alternatively, you can press Ctrl + 1 to open the Format Cells dialog box.
5. In the Format Cells dialog box, go to the "Number" tab.
6. Under the "Category" section, select "Accounting".
7. Set the decimal places to 0 by clicking on the "0" button in the "Decimal places" section.
8. Click on the "OK" button to apply the formatting.
Now, the range F15:H15 will display the total actual hours in the Accounting number format with no decimal places.