Excel Calculate overtime from existing spreadsheet.
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.