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