+ Reply to Thread
Results 1 to 4 of 4

New & need help on formulas for calculating time, time 1/2 & double time for payroll

  1. #1
    Registered User
    Join Date
    11-21-2012
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    New & need help on formulas for calculating time, time 1/2 & double time for payroll

    Hi - First ever forum & consequently first ever post! So please be kind I need help on calculating a formula that works backwards from total hours worked daily. First 7.2 hours are regular pay, next 2 hours are time and a half anything following this is double time. I don't need the calculation of pay rates - just the hour totals. However if working under 7.2 hours (or not at all) it has to reflect accordingly. I have been able to get the formulas for the regular & double time - but not the tricky 2 hours in the middle. =MIN($B$11,Sheet1!B3) this formula works for the regular =MAX(0,B5-2) and this works for double time (anything after 7.2 + 2). Any help would be greatly appreciated, as my brain is frazzled at the moment

  2. #2
    Forum Contributor
    Join Date
    11-05-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    229

    Re: New & need help on formulas for calculating time, time 1/2 & double time for payroll

    Hi Angie,

    Welcome to the forum!

    I've attached a workbook for you, and hopefully, this is what you are looking for. If not, let me know.

    Don't forget to click the little star to the left of this post if you feel I helped!
    Attached Files Attached Files
    Taming the Excel dragon... www.TheExcelphile.com

  3. #3
    Registered User
    Join Date
    11-21-2012
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: New & need help on formulas for calculating time, time 1/2 & double time for payroll

    Thank you TheExcelphile! Saved me a lot of thinking, especially as I don't know excel formulas that well. Excuse my ignorance , but I can't find the star to click on the left (you have helped and answered my question perfectly)!

  4. #4
    Registered User
    Join Date
    11-21-2012
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: New & need help on formulas for calculating time, time 1/2 & double time for payroll

    Found it (sorry just had to look harder!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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