# Shift diff timecard

1. ## Shift diff timecard

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.

2. ## Re: Shift diff timecard

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.

3. ## Re: Shift diff timecard

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)