Firstly ensure that all cells are formatted correctly to ensure they will add up the lines/ columns correctly. For example, ensure that where you enter your clocking in and out times, the cells are formatted as time. Most time cards set out in EXCEL will have three main rows; top row for total hours; middle row for regular hours and bottom row for overtime hours.
If the cell for Total hours, Monday is cell B1, then:
The formula in cell B2 "Regular Hours" is:
=IF(B1>8,8,B1)
the formula in cell B3 "Overtime hours" is:
=IF(B1>8,B1-8,0)
You simply fill the Total hours in cell B1, and the Regular Hours (cell B2) and Overtime Hours (cell B3) will be automatically calculated and filled.
While most of us have seen and may even have used Excel spreadsheets, few really understand the power of excel formulas. Excel Formulas is one of the backbones of the highly versatile program, offering the user the limitless ability to perform complex calculations while tracking data.
There are many different uses for Excel, from making invoices to tracking employee hours (which is what this question mentioned) and figuring out deductions. While many people understand how excel formulas work few people know how to make them work, which is where the real power and flexibility of this program lies. If you have ever had to crunch numbers for your business, as an employer or even when trying to create and stick to a budget at home you know how handy a custom spreadsheet can be for these tasks.
This almost limitless nature of Excel makes it very difficult to get a full grasp of. Each function requires knowledge of a certain formula in order to work out the required sums. There are, however, many books that can be purchased giving detailed examples of the different functions of Excel with examples of formula; such information can also be found on Excel related online forums.
If the cell for Total hours, Monday is cell B1, then:
The formula in cell B2 "Regular Hours" is:
=IF(B1>8,8,B1)
the formula in cell B3 "Overtime hours" is:
=IF(B1>8,B1-8,0)
You simply fill the Total hours in cell B1, and the Regular Hours (cell B2) and Overtime Hours (cell B3) will be automatically calculated and filled.
While most of us have seen and may even have used Excel spreadsheets, few really understand the power of excel formulas. Excel Formulas is one of the backbones of the highly versatile program, offering the user the limitless ability to perform complex calculations while tracking data.
There are many different uses for Excel, from making invoices to tracking employee hours (which is what this question mentioned) and figuring out deductions. While many people understand how excel formulas work few people know how to make them work, which is where the real power and flexibility of this program lies. If you have ever had to crunch numbers for your business, as an employer or even when trying to create and stick to a budget at home you know how handy a custom spreadsheet can be for these tasks.
This almost limitless nature of Excel makes it very difficult to get a full grasp of. Each function requires knowledge of a certain formula in order to work out the required sums. There are, however, many books that can be purchased giving detailed examples of the different functions of Excel with examples of formula; such information can also be found on Excel related online forums.
