I have a report from a payroll system that a customer uses that calculates overtime hours incorrectly. For example an employee may show 48 hours regular time in one pay period and 4 hours over time. I need to have the regular time hours caped at 40 and the extra hours moved to the same employee on their over time line. I'm attaching an example to make things a little easier to understand. There are also cases where and employee will show 48 hours regular time and no line for overtime. In those cases I need to add a line for overtime for that employee.
I added a concatenation column I as you had previously mentioned. This moved the Regular and Overtime hours columns to J & K, using formulas:
Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.