|
| 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
October 27th 08, 02:22 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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
October 27th 08, 02:39 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
October 27th 08, 02:39 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!
|
|
#4
October 27th 08, 02:42 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!
|
|
#5
October 27th 08, 02:43 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
October 27th 08, 02:51 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! > > >
|
| 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 09: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 04:28 PM |
| need help w/formula for calculating overtime hours | jv749297 | Excel Worksheet Functions | 1 | January 17th 05 07:54 PM |
Linear Mode
