Our company time sheet database is created each week, with each job performed entered each day. Everyone's time is entered as regular(REG) by default. Currently we have to go in and look and see if an employee reached overtime and if so, change REG to OT. One example that takes an additional step would be of a work week ending 9/8, someone might have 39 hours on 9/7 and then work three additional hours on 9/8. In that instance the three hours would have to be split by adding an additional row and code one row for 1 hour of REG and the new row 2 hours for OT.
The table is set up in the following way; Column A is employee ID, Column M is the column with REG, Column P is hours worked for that entry and Column R is the date the work was performed. Some of the other columns do contain values, but they are associated to location, job number, etc(non essential, but would need to be copied and pasted for the instances when hours are split). Would it be possible to create a macro that could look at the sheet, identify the employee ID, then look at the total hours, assess if more than 40 hours were worked, change code in Column M to OT if overtime was reached, and also split the time with an additional row if necessary?
The table is set up in the following way; Column A is employee ID, Column M is the column with REG, Column P is hours worked for that entry and Column R is the date the work was performed. Some of the other columns do contain values, but they are associated to location, job number, etc(non essential, but would need to be copied and pasted for the instances when hours are split). Would it be possible to create a macro that could look at the sheet, identify the employee ID, then look at the total hours, assess if more than 40 hours were worked, change code in Column M to OT if overtime was reached, and also split the time with an additional row if necessary?