Remember Me?

#1
October 27th 08, 03:22 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Oct 2008 Posts: 7
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
October 27th 08, 03:39 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Mar 2007 Posts: 120
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
October 27th 08, 03:39 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jun 2008 Posts: 2,420
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, 03:42 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 4,393
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, 03:43 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Oct 2008 Posts: 7
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
October 27th 08, 03:51 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Oct 2008 Posts: 7
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 Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Lee Ann[_2_] Excel Worksheet Functions 1 September 10th 08 04:31 AM Louie Excel Worksheet Functions 8 December 16th 07 10:41 PM OTVs Regular Excel Worksheet Functions 1 September 13th 07 08:24 AM Zack Excel Worksheet Functions 5 November 23rd 05 05:28 PM jv749297 Excel Worksheet Functions 1 January 17th 05 08:54 PM

All times are GMT +1. The time now is 02:01 PM.