+ Reply to Thread
Results 1 to 1 of 1

Shift Differential for 3 shifts

  1. #1
    Registered User
    Join Date
    03-16-2016
    Location
    Atlanta, GA
    MS-Off Ver
    2010
    Posts
    1

    Question Shift Differential for 3 shifts

    NEED HELP IN EXCEL!!!

    I am working on an excel sheet to calculate shift differentials. I partially have it figured out but I also think I’m way off. I have three shifts
    Shift 1 = 6am – 2pm
    Shift 2 = 2pm – 10pm
    Shift 3 = 10pm – 6am

    What I need to happen is to be able to put in the time an employee clocked in and clocked out and the excel calculate how many hours where in each shift.

    For Example:
    Clocked In: 5:52 AM
    Clocked Out: 6:00 PM

    Time in 1st Shift: 8.000 Hrs
    Time in 2nd Shift: 4.000 Hrs
    Time in 3rd Shift: 0.133 Hrs

    Is anyone proficient in Excel who can help me out with this. I almost have the formula for first shift, however, if there is no time spent in 1st shift, the equation defaults to 8 hrs, when it should be 0. Here is a link to the file SHIFT DIFF TRIAL.xlsx. Let me know if you have any questions. Any help is appreciated. 

    Please download the file, do not edit from OneDrive. The paperclip is not letting me upload an attachment, so this is the best I can do.
    Last edited by spirogeisel; 03-16-2016 at 02:20 PM.

+ 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. Complex shift differential calculation (as only a gov't could make this up)
    By jholter60 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-18-2014, 06:43 PM
  2. Timesheet calculations with overtime and shift differential
    By JHSVic in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-17-2014, 10:57 AM
  3. Need help to calulate shift differential time.
    By chrisstiff1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-18-2013, 09:29 AM
  4. Track employees which cross shifts and counted one time each shift
    By Macileo in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-24-2013, 02:20 AM
  5. identify differential hours in a shift that goes over midnight
    By CanYouDoThis? in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-08-2012, 03:20 PM
  6. Shift roster for 3 shifts
    By shivaraj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-24-2011, 06:35 AM
  7. Function that can identify Shift Differential...
    By rsstites in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-14-2008, 06:44 PM
  8. shift differential
    By flyeaglesfly in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2008, 04:09 PM

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