+ Reply to Thread
Results 1 to 4 of 4

Overtime and Regular Pay Calculator

  1. #1
    Registered User
    Join Date
    06-02-2010
    Location
    toronto
    MS-Off Ver
    Excel 2003
    Posts
    7

    Overtime and Regular Pay Calculator

    Hi,

    I'm trying to make an overtime calculator as follows:
    -it calculates 40hrs per week at $11 per hour (constant every week) unless it's short week e.g. 35hrs than it calculates 35hrs at $11 per hour
    -any hours over 40hrs are overtime and are calculated at $16 per hour
    I can't figure out the "if" statement for this calculation.
    Can somebody help me? My work file is attached.
    Attached Files Attached Files

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,335

    Re: Overtime and Regular Pay Calculator

    Error in calculation
    Last edited by vlady; 11-17-2011 at 03:02 AM. Reason: Error in calculation
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Registered User
    Join Date
    02-04-2011
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: Overtime and Regular Pay Calculator

    Hi,

    I have not used "IF" statement. But this may help you a little?

    Mick
    Attached Files Attached Files

  4. #4
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,335

    Re: Overtime and Regular Pay Calculator

    OK. Hope this one works.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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