light, easy training on calculating hours and minutes in excel

Excel Timesheets	Add & Convert	General Knowledge
Part A. Create a basic Excel Timesheet	Add up Hours in Excel	How does excel calculate hours
Part B. Insert Unpaid Lunch Breaks	Convert Conventional Hours into a Decimal #	How does excel calculate dates
Part C. Calculate Overtime Pay	Convert Hours and Minutes into Minutes	Express Log in and Log out in Excel
Timesheets for Night Shifts	Average Hours ignoring Zero's and Error Values	Entering only the last 2 digits of a year

Average hours calculator

ignoring zeros's and error valuesHow to calculate Average in Excel:
A. Average of numbers in a contiguos row or column
B. Average of numbers that are not in a contiguous row or column
C. Average Hours ignoring Zero's and Error Values

A. Average of numbers in a Contiguos Row or Column:
If your data is in cells A1:A10, type:
=AVERAGE(A1:A10)

B. Average of numbers that are not in a contiguous row or column:
If your data is in cells A1,A4 and B5, type:
=AVERAGE(A1,A4,B5)

C. Average Hours ignoring Zero's and Error Values
If you would like to get an accurate average, excluding zero's & error values, and your data is in cells A1:A10, type
=SUMIF(A1:A10,">0")/COUNTIF(A1:A10,">0")

Excel, all the time.