+ Reply to Thread
Results 1 to 4 of 4

Calculating Cost of Hours Worked

  1. #1
    Registered User
    Join Date
    08-26-2013
    Location
    Alberta
    MS-Off Ver
    Excel 2003
    Posts
    5

    Calculating Cost of Hours Worked

    I know this probably has to be an 'if' statement, but just can't get it worked out.
    What I have is a Row of hours worked per week and need to calculate the cost @ $50. / hour and 1.5x ($75) for hours over 40 hours in the week.

    A B C D E
    60 10 48 56.5 15

    The formula I used =SUM(A1*50)+((A1-40)*25)

    Works fine if hours are over 40, but doesn't work for those weeks under 40.
    Any help would be appreciated!

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Calculating Cost of Hours Worked

    Maybe like this.

    Please Login or Register  to view this content.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    08-26-2013
    Location
    Alberta
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Calculating Cost of Hours Worked

    Excellent - Thanks for the quick response!!

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Calculating Cost of Hours Worked

    Thanks for the reply.

    Glad I could help.

+ 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. Calculating actual hours worked only in core hours
    By Val C in forum Excel General
    Replies: 3
    Last Post: 02-27-2013, 01:54 AM
  2. Replies: 0
    Last Post: 05-14-2012, 05:36 PM
  3. Calculating Hours worked by day
    By rapscalli in forum Excel General
    Replies: 3
    Last Post: 05-04-2012, 06:32 AM
  4. Calculating basic hours worked, between a time range and premium hours worked
    By RoyLittle0 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-07-2012, 06:59 AM
  5. Replies: 0
    Last Post: 01-05-2012, 06:23 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