If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#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! 
Ads 
#2




Formula for Overtime hours in a spreadsheet
just an IF function would do
=IF(f38>40, 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(f38>40, 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! > > > 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Formula to Compute Overtime hours  Lee Ann[_2_]  Excel Worksheet Functions  1  September 10th 08 04:31 AM 
overtime hours formula  Louie  Excel Worksheet Functions  8  December 16th 07 10:41 PM 
if then formula for total time ;overtime hours versus regular  OTVs Regular  Excel Worksheet Functions  1  September 13th 07 08:24 AM 
Overtime Hours  Zack  Excel Worksheet Functions  5  November 23rd 05 05:28 PM 
need help w/formula for calculating overtime hours  jv749297  Excel Worksheet Functions  1  January 17th 05 08:54 PM 