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

Hi Karl,

About a month or so ago when you posted I replied offering
a sample workbook. You never replied back so I deleted the
workbook. If you want to email the file, I'll take a look
at it.

(E-Mail Removed)

Biff

>-----Original Message-----
>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
>
>.
>