K
Karl
Calculating Time & A Half On A Time Card
Could any one tell me what formula to use to calculate
time & a half on my time card?
The tricky part is that; this is for a time card that is
on a 2-week schedule. Where anything over 40 hours in week
1 is paid as time & a half, and anything over 40 hours in
week 2 is paid as time & a half.
Keep in mind that time & a half is not figured out by the
day but by the week.
In other words if a normal work day is 8 hours and I work
10 hours, I'm paid for 10 hours straight time & not over
time.
But if I work 42 hours in a week, 40 hours is paid as
straight time & 2 hours is paid as time & a half.
Here is the equation that I have come up with so far. It's
does work if I work less than 40 hours but for some reason
it doesn't if I work more than 40 hours.
=IF(G97>40,(G97-40)*(K97*1.5*24)+(40*K97*24),(G97*K97*24))
Cell G97 is the number of Hours (cell formatted like this
3:00) I worked for the week.
Cell K97 is the amount I get paid.
And the # 24 is because the of the way the computer stores
hours
So if I worked 40:45 hours and I get paid $8.00 per hour
the answer should be $335.00.
But I get an answer of $326.00.
If you would like I can e-mail with an attachment of the
file I'm working with.
Thanks for the help
Could any one tell me what formula to use to calculate
time & a half on my time card?
The tricky part is that; this is for a time card that is
on a 2-week schedule. Where anything over 40 hours in week
1 is paid as time & a half, and anything over 40 hours in
week 2 is paid as time & a half.
Keep in mind that time & a half is not figured out by the
day but by the week.
In other words if a normal work day is 8 hours and I work
10 hours, I'm paid for 10 hours straight time & not over
time.
But if I work 42 hours in a week, 40 hours is paid as
straight time & 2 hours is paid as time & a half.
Here is the equation that I have come up with so far. It's
does work if I work less than 40 hours but for some reason
it doesn't if I work more than 40 hours.
=IF(G97>40,(G97-40)*(K97*1.5*24)+(40*K97*24),(G97*K97*24))
Cell G97 is the number of Hours (cell formatted like this
3:00) I worked for the week.
Cell K97 is the amount I get paid.
And the # 24 is because the of the way the computer stores
hours
So if I worked 40:45 hours and I get paid $8.00 per hour
the answer should be $335.00.
But I get an answer of $326.00.
If you would like I can e-mail with an attachment of the
file I'm working with.
Thanks for the help