I have an Excel sheet where I have to keep track of overtime.
The report I receive in Excel has all the hours worked in the cell.
Example.
Column A heading (A1) reads "Regular Hours".
Column B heading (B1) reads "Overtime Hours".
Cell A2 under column A shows the hours as 48, and cell B2 under column B shows 0.
It is supposed to be 40 under A2 and 8 for B2.
Basically it is a bug in the program that exports the time.
So instead I would like to add a button in a new blank Excel sheet. (This I know how to do)
Then I can just copy and paste from the report into the new Excel sheet. (This I know how to do also)
Then I want to click the button that will take the 48 in A2, change it to 40, and put the remainder of 8 into B2.
Now if the regular hours is less than 40, then I want it to leave it alone.
Sometimes the hours are 36 in A2, so obviously there is no overtime anyway for B2.
Now there is about 75 rows of time, so it would need to go and do this for all 75 rows.
So, long story short:
Need it to change the 48 to 40, and put the remainder in the next cell which is B2 in this case.
I hope this makes sense to everyone.
The report I receive in Excel has all the hours worked in the cell.
Example.
Column A heading (A1) reads "Regular Hours".
Column B heading (B1) reads "Overtime Hours".
Cell A2 under column A shows the hours as 48, and cell B2 under column B shows 0.
It is supposed to be 40 under A2 and 8 for B2.
Basically it is a bug in the program that exports the time.
So instead I would like to add a button in a new blank Excel sheet. (This I know how to do)
Then I can just copy and paste from the report into the new Excel sheet. (This I know how to do also)
Then I want to click the button that will take the 48 in A2, change it to 40, and put the remainder of 8 into B2.
Now if the regular hours is less than 40, then I want it to leave it alone.
Sometimes the hours are 36 in A2, so obviously there is no overtime anyway for B2.
Now there is about 75 rows of time, so it would need to go and do this for all 75 rows.
So, long story short:
Need it to change the 48 to 40, and put the remainder in the next cell which is B2 in this case.
I hope this makes sense to everyone.