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.

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.