Follow easy instructions on how to: Add up hours, Convert Hours, and Average Hours
Question: I am adding up hours in Excel. My total is incorrect. What should I do?
Short Answer: Change the Format of your total cell to: [h]: mm
Long Answer: see http://www.calculatehours.com/excel-how-to/add-hours.html
Question: How do I convert conventional hours into a decimal number?
To convert hours using a calculator:
Divide the minutes by 60.
To convert hours using Excel:
Change the cell format to "Number" with 2 decimal places and multiply it by 24
Long answer, see: http://www.calculatehours.com/excel-how-to/convert-hours-to-Decimal.html
Type your hours and minutes in an hh:mm format
Click on Format Cells
On the Number Tab, under "custom", type [m]
We do Excel Right.
If you would like to get an accurate average, excluding zero's & error values, and your data is in cells A1:A10, type
Excel, all the time.