Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

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

1. I agreed to these rules
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.

Excel Video Tutorials / Excel Dashboards Reports

2. I agreed to these rules
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. Super Moderator
Join Date
14th January 2005
Location
Cyprus
Posts
2,252

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

Hi Blwol,

Welcome.

Excel Video Tutorials / Excel Dashboards Reports

4. Super Moderator
Join Date
26th January 2003
Location
Derbyshire,UK
Posts
19,833

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

Welcome to Ozgrid. Try this amendment & additional formula

5. I agreed to these rules
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

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

#### 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