+ Reply to Thread
Results 1 to 2 of 2

Calculate Extra Earnings Per Week

  1. #1
    Registered User
    Join Date
    09-02-2020
    Location
    Canada
    MS-Off Ver
    365
    Posts
    3

    Calculate Extra Earnings Per Week

    Hello,

    I have a list of a few hundred employees.How can I find out how much an employee earned for the extra hours they worked during a week? The week in this case starts on Sunday and end on Saturday.


    The employee has a set number of hours they are scheduled to work each week, however, they may work more than their regular scheduled hours during that week. So how can I find out exactly how many extra hours they worked (beyond their regular schedule) and how much "extra" money they earned?


    Thanks,
    Ceara
    Attached Files Attached Files

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Calculate Extra Earnings Per Week

    You need to add an extra column with the week number and one with this formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    The first part makes that the extra time is only listed once per employee per week.
    Attached Files Attached Files
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

+ 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. Formula to calculate deductions in 48-week period and yield a 52-week value
    By thenuguy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-29-2019, 07:10 PM
  2. Calculate the Week in the quarter using Fiscal week and a Date
    By dalfane177 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-14-2016, 04:09 PM
  3. [SOLVED] Calculate Week Range from Week Number, Month and Year?
    By A108A108 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 05-07-2016, 03:11 PM
  4. Replies: 5
    Last Post: 09-25-2013, 01:48 PM
  5. [SOLVED] excel hlep to calculate the week no from dispatch to closed calls week wise
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-05-2013, 04:53 AM
  6. Automatically calculate earnings per win?
    By batjl9 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2011, 01:26 PM
  7. Excel 2007 : calculate regular earnings seperate from OT
    By ionek2004 in forum Excel General
    Replies: 3
    Last Post: 06-20-2009, 02:59 PM

Tags for this Thread

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