Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Calculating Overtime (Time and a half & Double)

  1. #1
    Join Date
    3rd December 2005
    Posts
    2

    Calculating Overtime (Time and a half & Double)

    I want to figure out formulas for calculating overtime for 'time-and-a-half' (in one column, G6) and one for 'double' (in another column, H6). Any hours over eight (8) are time-and-a-half, and over twelve (12) as double time. I also have a column (I6) that sums the amount for total overtime paid. I attached my Excel file if it helps. Thanks.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    3rd December 2005
    Posts
    19

    Re: Calculating Overtime (Time and a half & Double)

    In cell G6,

    =MIN(D6*E6*($L$2-1),4*E6*($L$2-1))

    In cell H6,

    =IF(D6>4,(D6-4)*E6*($L$3-1),0)

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    14th January 2005
    Location
    Cyprus
    Posts
    2,252

    Re: Calculating Overtime (Time and a half & Double)

    Hi Blwol,

    Welcome.

    I had a go too.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    17,467

    Re: Calculating Overtime (Time and a half & Double)

    Welcome to Ozgrid. Try this amendment & additional formula
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    About me.

  5. #5
    Join Date
    3rd December 2005
    Posts
    2

    Re: Calculating Overtime (Time and a half & Double)

    Thank you. This works.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Calculating Hours Worked With Overtime Clause
    By error#9 in forum EXCEL HELP
    Replies: 8
    Last Post: July 25th, 2007, 01:24
  2. Calculating Full-width Half-max (fwhm)
    By rabarton in forum EXCEL HELP
    Replies: 2
    Last Post: June 28th, 2007, 00:25
  3. Half & Double Cell Values
    By Hitokiri in forum EXCEL HELP
    Replies: 8
    Last Post: November 21st, 2006, 07:21
  4. Replies: 6
    Last Post: March 19th, 2006, 01:24
  5. Double Overtime Timesheet
    By ater19654 in forum EXCEL HELP
    Replies: 4
    Last Post: March 9th, 2006, 15:54

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
  •  
porno