Results 1 to 15 of 15

How to automate shift pay/time for split shifts with given constraints.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-25-2020
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    513

    How to automate shift pay/time for split shifts with given constraints.

    Is there a way to set up the following for split shifts.

    Staff get the following;

    10 minutes for Report Time
    5 minutes for Clear time

    If the break between both shifts is less than 2 hours then it is paid at straight time.

    The maximum day span allowed is 14 hours.

    Due to these rules, for determining pay, the min and max would be these.

    STR 7.25
    OT 0

    STR 8
    OT 6

    Though 99% there will never be a job that pays 6 hours overtime. This is just an example for the forum.

    Below is one of the rules, word for word. My best interruption of this is the yellow highlighted portions in the workbook, though I could be wrong.

    All employees shall be paid for overtime at the rate of one and one‑half times the hourly rate for all work performed after the completion of eight (8) hours work or ten (10) hour day span daily. Jobs having a day span in excess of eleven hours (11) minimum pay at the end of eleven (11) hours shall be eight (8) times the hourly rate and work performed thereafter shall be paid in addition to the minimum guarantee of eight (8) hours.

    From management: Employees start to receive 1.5 pay at 10 hours of a day span. They also are guaranteed 8 ST hours at 11 hours span if that many ST hours have not yet been accrued. In this second scenario, the employee would then get OT for the remainder of their work.

    If you can help generate all of this, it would be greatly appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Split breakdown time between shifts
    By krzysiekpirat in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-29-2021, 10:33 AM
  2. [SOLVED] SUM of Shift-wise and of both the Shifts
    By RavindraK in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-08-2018, 12:53 AM
  3. Shift Management Changing shifts based on last shift of current month
    By zenod in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-22-2018, 04:06 AM
  4. [SOLVED] Shift Differential for 3 shifts
    By spirogeisel in forum Excel General
    Replies: 0
    Last Post: 03-16-2016, 01:51 PM
  5. 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
  6. [SOLVED] Split Shift & Time Managment Grid based on 24 hour clock in 15 min increments
    By paxile2k in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-18-2013, 08:23 PM
  7. Shift roster for 3 shifts
    By shivaraj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-24-2011, 06:35 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