Over time/splitting hours Time sheet

y3tter

Board Regular
Joined
Nov 11, 2012
Messages
147
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?
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top