Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default calculating pay with and without overtime

need help with a formula to calculate gross pay with 1.5 overtime rate with
<= 40 hrs Please help Thanks

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,344
Default calculating pay with and without overtime

Hi,

Suppose the hours are in A1 and the rate is in J12 then

=IF(A1<=40,A1*$J$12,40*$J$12+(A1-40)*1.5*$J$12)

--
Thanks,
Shane Devenshire


"lebanonfamous" wrote:

need help with a formula to calculate gross pay with 1.5 overtime rate with
<= 40 hrs Please help Thanks

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default calculating pay with and without overtime

Try this:

A1 = hourly rate
A2 = total hours (in decimal format: 48)

=A1*MIN(40,A2)+A1*1.5*MAX(0,A2-40)

--
Biff
Microsoft Excel MVP


"lebanonfamous" wrote in message
...
need help with a formula to calculate gross pay with 1.5 overtime rate
with
<= 40 hrs Please help Thanks



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,344
Default calculating pay with and without overtime

Hi,

Here is a shorter formula to do the same thing with the rate in B1 and the
hours in A1


=MAX(A1,40+(A1-40)*1.5)*$B$1

--
Thanks,
Shane Devenshire


"lebanonfamous" wrote:

need help with a formula to calculate gross pay with 1.5 overtime rate with
<= 40 hrs Please help Thanks

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default calculating pay with and without overtime

thx needed the help brain freeze

"T. Valko" wrote:

Try this:

A1 = hourly rate
A2 = total hours (in decimal format: 48)

=A1*MIN(40,A2)+A1*1.5*MAX(0,A2-40)

--
Biff
Microsoft Excel MVP


"lebanonfamous" wrote in message
...
need help with a formula to calculate gross pay with 1.5 overtime rate
with
<= 40 hrs Please help Thanks






  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default calculating pay with and without overtime

thx brain freeze here needed the help


"ShaneDevenshire" wrote:

Hi,

Here is a shorter formula to do the same thing with the rate in B1 and the
hours in A1


=MAX(A1,40+(A1-40)*1.5)*$B$1

--
Thanks,
Shane Devenshire


"lebanonfamous" wrote:

need help with a formula to calculate gross pay with 1.5 overtime rate with
<= 40 hrs Please help Thanks

  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default calculating pay with and without overtime

You're welcome!

--
Biff
Microsoft Excel MVP


"lebanonfamous" wrote in message
...
thx needed the help brain freeze

"T. Valko" wrote:

Try this:

A1 = hourly rate
A2 = total hours (in decimal format: 48)

=A1*MIN(40,A2)+A1*1.5*MAX(0,A2-40)

--
Biff
Microsoft Excel MVP


"lebanonfamous" wrote in
message
...
need help with a formula to calculate gross pay with 1.5 overtime rate
with
<= 40 hrs Please help Thanks






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
calculating overtime Chase Michaels New Users to Excel 1 May 16th 07 05:43 PM
Calculating overtime bunnyc Excel Discussion (Misc queries) 1 February 21st 06 01:36 AM
Calculating Overtime sam13484 via OfficeKB.com Excel Worksheet Functions 1 February 3rd 06 04:20 PM
Need help calculating overtime to date BVHis Excel Worksheet Functions 8 January 9th 06 06:59 PM
Calculating overtime jennerifw New Users to Excel 3 August 9th 05 09:33 PM


All times are GMT +1. The time now is 06:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"