Home 
Search 
Today's Posts 
#1




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




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




Formula for Overtime hours in a spreadsheet
=F38*10+MAX(0,F3840)*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! 
#4




Formula for Overtime hours in a spreadsheet
=MIN(40,F38)*10+MAX(0,F3840)*15
for easier update =(MIN(40,F38)+MAX(0,F3840)*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! 
#5




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




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,F3840)*15 for easier update =(MIN(40,F38)+MAX(0,F3840)*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! 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Formula to Compute Overtime hours  Excel Worksheet Functions  
overtime hours formula  Excel Worksheet Functions  
if then formula for total time ;overtime hours versus regular  Excel Worksheet Functions  
Overtime Hours  Excel Worksheet Functions  
need help w/formula for calculating overtime hours  Excel Worksheet Functions 