Closed Thread
Results 1 to 2 of 2

Formula for calculating daily total pay when Cumulative hours go over 40

Hybrid View

  1. #1
    Registered User
    Join Date
    10-21-2017
    Location
    Las Vegas, NV
    MS-Off Ver
    Excel 2016
    Posts
    4

    Formula for calculating daily total pay when Cumulative hours go over 40

    I have a spreadsheet which:

    Totals the days hours worked in Column (O9 thru O15)

    Totals cumulative hours worked so for in a week in Column (P9 thru P15)

    Totals the daily pay in a column (Q9 through Q15).

    I have Reg Pay Rate Amount in Cell (R2) and the Overtime Pay Rate Amount in Cell (R4).

    What I need is a formula so that when the total in the Cumulative Hours to that point for the week is under 40 it multiplies that days hours x the Reg Rate and when the Cumulative Hours Column goes over 40 hours it will it multiple that days hours x the Overtime Rate.

    Keeping in mind that in one day it might be needed to calculate several hours in that same day @ Reg Rate and several hours @ Overtime Rate.

    Because we work 12 hour tours per day generally by the end of day four in the week, I have 48 hours total in the Cumulative Column (so that day would need to calculate both rates. It would need to calculate 4 hours @ Reg rate and 8 hours at Overtime Rate)

    I am new to this site and not sure if you can upload spreadsheets for you to view because I do not see an option to do it.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Formula for calculating daily total pay when Cumulative hours go over 40

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

    Thread Closed.

    https://www.excelforum.com/excel-for...over-40-a.html
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed 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 total hours used daily?
    By voldo in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-17-2016, 07:19 PM
  2. Calculating Weekly Total Hours from Daily Times
    By RFernandez in forum Excel General
    Replies: 7
    Last Post: 04-12-2016, 07:13 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. [SOLVED] calculating cumulative daily overtime for 20+ staff.
    By Tim1576 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-25-2014, 07:02 AM
  5. Adding daily run hours to cumulative total hours
    By Rodstew in forum Excel General
    Replies: 8
    Last Post: 08-08-2012, 07:10 PM
  6. daily total hours
    By carolynkeene in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-08-2007, 05:52 PM
  7. Cumulative Time Problem calculating more than 24 hours.
    By J in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-20-2005, 11: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