+ Reply to Thread
Results 1 to 2 of 2

help needed making a simple payroll calculator

  1. #1
    Registered User
    Join Date
    04-19-2017
    Location
    miami
    MS-Off Ver
    2016
    Posts
    3

    Question help needed making a simple payroll calculator

    please forgive me if this is a bit of a noob question or if i overlooked some forum custom or rule in asking this here.

    i have a payroll calculator where all the hours are summed up and shown in a cell. I'm trying to have it only show a maximum of 40 hours with any additional hours being shown in a different cell. the purpose of this being to separate regular hours from overtime hours.
    I've been trying to figure this out using =SUMIF(R28:R34,">40") and have been unsuccessful

    If anyone could show me how to properly do this the help would be greatly appreciated.


    Screen Shot 2017-04-19 at 12.59.14 PM.png

    EDIT: a bit more clarification. i want the TOTAL HOURS to cap off at 40 and i want a seperate formula to either use that sum or add up the numbers itself and show all hours logged after 40 hours
    Last edited by aphatmc; 04-19-2017 at 01:13 PM.

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily NL, sometimes UK
    MS-Off Ver
    2010
    Posts
    2,270

    Re: help needed making a simple payroll calculator

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Welcome to the forum.

    In your 'Total Hours' cell (R35 I think?), use this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    In your 'Overtime' cell (or whatever you want to call it), use this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Make sure both cells are formatted as [h]:mm or you'll never see more than 23:59.

    Hope that does what you need.
    Regards,
    Aardigspook

    My internet connection can be intermittent, so sometimes I may not reply quickly to questions. Sorry - it's not personal and I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

+ 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. [SOLVED] Payroll Calculator
    By heather034 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-20-2015, 03:52 PM
  2. Payroll Tax Calculator
    By fishead in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-14-2013, 01:48 AM
  3. Replies: 0
    Last Post: 01-10-2013, 03:07 PM
  4. Help needed in making CGPA calculator
    By TokyoDrift in forum Excel General
    Replies: 1
    Last Post: 07-13-2009, 02:24 PM
  5. Adding payroll stubs payroll calculator
    By Sable in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-05-2006, 12:40 PM
  6. [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
  7. [SOLVED] Payroll calculator template
    By Eagle View Construction in forum Excel General
    Replies: 0
    Last Post: 05-02-2005, 09: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