+ Reply to Thread
Results 1 to 4 of 4

Payroll Calculator

  1. #1
    Registered User
    Join Date
    05-20-2015
    Location
    Los Angeles
    MS-Off Ver
    2013
    Posts
    2

    Payroll Calculator

    I'm trying to make a payroll calculator where any hours over 40 gets double time if they are full time and time and a half if they are part time. Double time being 2 and time and a half 1.5. I can't seem to figure out a correct formula to calculate only the hours over 40 as double or time and a half to get their hourly salary. I'm sure it's a simple solution and I'm just over complicating it. If anyone could help me, I'd really appreciate it, Thanks!
    Attached Files Attached Files

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Payroll Calculator

    =H3*B$9+MAX(0,H3-40)*IF(B3="Full Time",B$9,B$9*0.5)
    Please Login or Register  to view this content.
    try the above in I3 and copy towards down
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    05-20-2015
    Location
    Los Angeles
    MS-Off Ver
    2013
    Posts
    2

    Re: Payroll Calculator

    That's it! Thank you!

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Payroll Calculator

    you are welcome and thanks for feedback

+ 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. Payroll Tax Calculator
    By fishead in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-14-2013, 01:48 AM
  2. [SOLVED] Adding payroll stubs payroll calculator
    By Sable in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-05-2006, 12:40 PM
  3. [SOLVED] what is tax status in Payroll calculator
    By liquid in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-01-2005, 12:05 AM
  4. [SOLVED] Payroll calculator template
    By Eagle View Construction in forum Excel General
    Replies: 0
    Last Post: 05-02-2005, 09:06 PM
  5. [SOLVED] payroll calculator in excel for canadians
    By sue in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-11-2005, 07:06 PM

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