Hi i need help modifying this doc so as to include a shift diff from 9pm - 6am of =$1.00/hr
the store is open 24hrs and only pays overtime on holidays and never pays double over time.
Please help
Hi i need help modifying this doc so as to include a shift diff from 9pm - 6am of =$1.00/hr
the store is open 24hrs and only pays overtime on holidays and never pays double over time.
Please help
Hello Bettyb84 and Welcome to Excel Forum.
Please add a new post to this thread that includes a file that shows us how you would manually prepare the Data Entry sheet to display the hours worked during the 9pm - 6am shift so that we can then attempt to automate the process using formulas/code.
We also need to see how holidays are going to be marked on the Data Entry sheet.
At that point it may be possible to produce some formulas/code that will replace the Double Overtime column on the Weekly, Bi Weekly and Monthly Timesheets with hours worked during the 9pm - 6am shift and to include hours worked on holidays with the overtime hours.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Looked at this a bit more and here is a possibility:
Replace the formula in the old Double Overtime column (now 9PM-6AM) with: =IF(C7="",0,IF(D7<H$3,H$3-D7,IF(D7>H$2,D7-H$2,IF(C7>H$2,C7-H$2,IF(C7<H$3,H$3-C7,0)))*24))
Modify the old Double Overtime Pay column to read: =IF('DATA ENTRY'!$H7="","",'DATA ENTRY'!$H7*SUM(I_T1_RT,1))
Pretty much the rest is just changing the column headers and adjusting the amount per hour in the old Double Overtime cells to read: =SUM(I_T1_RT,1)
Note that there are times in cells H2:H3 on the Data Entry sheet. Those times could be hidden for aesthetic purposes by changing the font color to white.
Let us know if you have any questions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks