+ Reply to Thread
Results 1 to 3 of 3

Shift diff timecard

  1. #1
    Registered User
    Join Date
    02-22-2021
    Location
    USA
    MS-Off Ver
    10
    Posts
    1

    Question 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.
    Please help
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    12,100

    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.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    12,100

    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.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 8
    Last Post: 02-17-2021, 09:18 AM
  2. Replies: 2
    Last Post: 02-18-2016, 11:52 PM
  3. Replies: 6
    Last Post: 08-28-2014, 02:44 AM
  4. Payroll Time Sheet with Shift diff
    By DEdmonson18 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-06-2014, 08:44 PM
  5. Replies: 0
    Last Post: 07-30-2013, 07:42 PM
  6. [SOLVED] Macro to send mail via lotus notes diff people diff attachment
    By mangeshp4 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-21-2013, 03:01 AM
  7. Replies: 0
    Last Post: 01-13-2005, 06:49 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1