Results 1 to 6 of 6

Overnight Weekend Work Schedule

Threaded View

  1. #1
    Registered User
    Join Date
    01-21-2014
    Location
    Lakeland, Florida
    MS-Off Ver
    2013
    Posts
    23

    Overnight Weekend Work Schedule

    My schedul created is almost perfect except for one feature i cannot figure out. My payroll stops time at midnight between friday and saturday (which ever day lol) but we have guys working between the hours of 10pm and 630am on fri nights which takes 2 hours on 1 week and 6 hrs on the next. right now this is formula =SUM(V17,S17,P17,M17,J17,G17,D17)*24 what do i need to add

    schedule2.xlsx
    Last edited by bdogg33830; 01-22-2014 at 09:57 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Weekend Work Schedule
    By gorram in forum Excel General
    Replies: 1
    Last Post: 11-28-2013, 06:08 PM
  2. Trouble with Weekend Rotation Schedule
    By stusic in forum Excel General
    Replies: 2
    Last Post: 07-18-2013, 01:48 PM
  3. Elapse time based on work hour less weekend and holidays
    By russellj in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-23-2013, 06:29 AM
  4. [SOLVED] Weekend nightmare how to work out week day and weekend rates Help Please
    By Sherburn Systems in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2012, 06:07 AM
  5. rotating 12 hour schedule shared with 3, one weekend off monthly
    By koalabusdriver in forum Excel General
    Replies: 1
    Last Post: 03-01-2005, 11:06 AM

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