Wednesday, March 13, 2013

How to Add Hours in Microsoft Excel


1. Create or open an Excel workbook that has hours that need to be totaled. The hours are formatted as h:mm.
2.
In the example at the left, the sum of the column results in an inaccurate number since Excel ignores hours that exceed 24. By reformatting the cell that holds the sum formula, we can correct this situation.
3. Right click in the cell that holds the sum formula, and then click on Format Cells.
4. On the Format Cells dialog box, click on the Number tab if it's not already displaying.
5.
Edit the custom setting, placing brackets around the 'h' as: [h]:mm .
6.
Click OK and you will see that the revised formatting has corrected the display value.

Blogger news