+ Reply to Thread
Results 1 to 9 of 9

FORMULA NEEDED: Shift Differential based on Day of week and hours...

Hybrid View

  1. 08-16-2017, 10:13 PM #1
    mark.k.conroy
    mark.k.conroy is offline
    Registered User
    Join Date
    08-16-2017
    Location
    Madison, WI
    MS-Off Ver
    2011
    Posts
    20

    Re: FORMULA NEEDED: Shift Differential based on Day of week and hours...

    THANKS! I added the year - Excel 2011 (for a mac too lol)
    Reply With QuoteRegister To Reply
  2. 08-16-2017, 10:22 PM #2
    FlameRetired
    FlameRetired is online now
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2502
    Posts
    13,702

    Re: FORMULA NEEDED: Shift Differential based on Day of week and hours...

    RE: Post #6

    Does this do it?
    Formula: copy to clipboard 
    =IF(WEEKDAY(A3,2)>5,E3-C3,(E3<C3)*("23:30"-"19:00")+MEDIAN(E3,"19:00","23:30")-MEDIAN(C3,"19:00","23:30"))


    RE: Post #7. Thank you for updating your profile including the Mac part. It helps.
    Dave
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Shift Pattern Adding Hours based on Shift etc
    By fgbuk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2016, 07:56 PM
  2. Need a formula to calculate time elapsed within work shift based on clocked in hours
    By MCS12 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-10-2016, 11:38 PM
  3. [SOLVED] Formula needed to total daily work hours and hours per week
    By amkampbell in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-24-2016, 07:33 PM
  4. Calculating shift hours above 40 per week
    By evansmike881 in forum Excel General
    Replies: 2
    Last Post: 05-02-2015, 05:54 AM
  5. trying to get 12 hour time format work hours/shift, with total per week with days off
    By mishii in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-21-2013, 05:45 PM
  6. 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
  7. 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1