Formula for Overtime hours in a spreadsheet
 

Hello-

I was wondering if there is a formula to automatically calculate time and a
half for any hours over forty?... I got total hours in one cell (f38) and
below that I got a formula for the total hours times 10 (=F38*10)... but what
formula should I use to calculate time and a half for anything over 40
hours?... everything under 40 obviously at 10 dollars an hour and anything
over forty at 15 dollars an hour... I know you smart, intelligent people got
the answer lol :0).... thank you!

Formula for Overtime hours in a spreadsheet
 

just an IF function would do

=IF(f3840, f38*15, f38*10)



"ChazFr" wrote:

Hello-

I was wondering if there is a formula to automatically calculate time and a
half for any hours over forty?... I got total hours in one cell (f38) and
below that I got a formula for the total hours times 10 (=F38*10)... but what
formula should I use to calculate time and a half for anything over 40
hours?... everything under 40 obviously at 10 dollars an hour and anything
over forty at 15 dollars an hour... I know you smart, intelligent people got
the answer lol :0).... thank you!

Formula for Overtime hours in a spreadsheet
 

=F38*10+MAX(0,F38-40)*0.5

--
__________________________________
HTH

Bob

"ChazFr" wrote in message
...
Hello-

I was wondering if there is a formula to automatically calculate time and
a
half for any hours over forty?... I got total hours in one cell (f38) and
below that I got a formula for the total hours times 10 (=F38*10)... but
what
formula should I use to calculate time and a half for anything over 40
hours?... everything under 40 obviously at 10 dollars an hour and anything
over forty at 15 dollars an hour... I know you smart, intelligent people
got
the answer lol :0).... thank you!

Formula for Overtime hours in a spreadsheet
 

=MIN(40,F38)*10+MAX(0,F38-40)*15
for easier update
=(MIN(40,F38)+MAX(0,F38-40)*1.5)*10
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"ChazFr" wrote in message
...
Hello-

I was wondering if there is a formula to automatically calculate time and
a
half for any hours over forty?... I got total hours in one cell (f38) and
below that I got a formula for the total hours times 10 (=F38*10)... but
what
formula should I use to calculate time and a half for anything over 40
hours?... everything under 40 obviously at 10 dollars an hour and anything
over forty at 15 dollars an hour... I know you smart, intelligent people
got
the answer lol :0).... thank you!

Formula for Overtime hours in a spreadsheet
 

thanks! you guys are the greatest lol!

"Raz" wrote:

just an IF function would do

=IF(f3840, f38*15, f38*10)



"ChazFr" wrote:

Hello-

I was wondering if there is a formula to automatically calculate time and a
half for any hours over forty?... I got total hours in one cell (f38) and
below that I got a formula for the total hours times 10 (=F38*10)... but what
formula should I use to calculate time and a half for anything over 40
hours?... everything under 40 obviously at 10 dollars an hour and anything
over forty at 15 dollars an hour... I know you smart, intelligent people got
the answer lol :0).... thank you!

Formula for Overtime hours in a spreadsheet
 

Thanks guys! Im just learning Excel.... its been about 6 years since I last
used it so this helps alot! Thanks!

"Bernard Liengme" wrote:

=MIN(40,F38)*10+MAX(0,F38-40)*15
for easier update
=(MIN(40,F38)+MAX(0,F38-40)*1.5)*10
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"ChazFr" wrote in message
...
Hello-

I was wondering if there is a formula to automatically calculate time and
a
half for any hours over forty?... I got total hours in one cell (f38) and
below that I got a formula for the total hours times 10 (=F38*10)... but
what
formula should I use to calculate time and a half for anything over 40
hours?... everything under 40 obviously at 10 dollars an hour and anything
over forty at 15 dollars an hour... I know you smart, intelligent people
got
the answer lol :0).... thank you!