Results 1 to 18 of 18

Formulas to Add shift penalty rates to specific times & days

Threaded View

  1. #1
    Registered User
    Join Date
    03-26-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2003
    Posts
    7

    Cool Formulas to Add shift penalty rates to specific times & days

    Hey everybody im trying to create a complete spreadsheet that calculates all my penalty rates and need a little help with some more advanced formulas so that it calculates it automatically , listed below are my penalty rates which im hoping somebody can edit the attatched spreadsheet and help me out

    Saturday - Time & a half
    Sunday Double Time
    Monday - Friday = Start before 07:00am 15% extra loading and finish after 19:00 is 20% loading also on monday friday anything over 8 hours is auto double time

    Your help would be greatly appreciated....
    Attached Files Attached Files
    Last edited by sman1; 04-01-2013 at 12:11 AM.

Thread Information

Users Browsing this Thread

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

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