+ Reply to Thread
Results 1 to 2 of 2

Overtime hours and different rates of pay

  1. #1
    Registered User
    Join Date
    08-10-2017
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    1

    Overtime hours and different rates of pay

    Hi

    I am having seriously difficulty trying to calculate the standard, overtime 1 and overtime 2 hours applicable to difference rates of rate on a daily basis.

    Standard rates apply 8am-4pm Mon to Thur and 8am-3.30pm Fri

    Hours thereafter are charged @ 1.3 the standard rate
    Midnight to 8am are charge @1.7 the standard rate
    Saturday first 4hrs are charged @ 1.3 the standard rate and thereafter @ 1.7 the standard rate
    All Sunday and Holidays are 1.7 the standard rate


    A 1/2 per day is standardly deducted for lunch

    I have attached what I have currently. any help would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Overtime hours and different rates of pay

    see attached workbook for some modification I did to your worksheet.
    I inserted new columns and formulas to calculate Std and Ov1, OV2 time for each day.
    You'll just have to add those rows to get the totals.
    Attached Files Attached Files
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

+ 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. [SOLVED] Calculating Overtime Hours for each Day on a 40+ Overtime per Week Basis
    By HumdrumPanic in forum Excel General
    Replies: 5
    Last Post: 09-30-2020, 12:55 PM
  2. Replies: 2
    Last Post: 01-17-2014, 02:22 PM
  3. how to calculate multiple overtime rates
    By fouthone in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-15-2012, 11:16 AM
  4. Calculating overtime on variable rates over the weekend
    By barrie.shardlow in forum Excel General
    Replies: 2
    Last Post: 11-03-2010, 05:41 PM
  5. Calculating overtime with 3 different pay rates
    By lostinexcelformulas in forum Excel General
    Replies: 6
    Last Post: 04-10-2009, 08:34 AM
  6. time sheets:overtime rates,
    By emmcee in forum Excel General
    Replies: 4
    Last Post: 08-24-2005, 02:05 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