Calculating time/overtime/rates for employees - sheet attached

Hi,
I have a problem and I'm hoping you can help.

1) At my workplace, people work all sorts of different hours. I need to be able to calculate how many hours someone worked in a day easily in column H. I have a comment in.
2) If someone works more than 12 hours in a day, they get time & a half - so if the normal rate is $26.44 and they worked 13 hours, 1 hour of that would need to be 1*0.5*26.44 and 12 of that would need to be 12*26.44 - how do I get it to do that in column I?
3) If someone works more than 40 hours total in a week, that difference needs to get calculated as overtime. So if someone worked 56 hours in a week, 16*0.5*26.44 and 40*26.44 would be what needs to happen in wages - column J.

Could you please help? I'm attaching my sheet with notes & please let me know if anything is unclear.

~S

I made a couple of adjustments to the post and file. I hoped to do it before you checked the thread, but I see from your profile that you viewed the thread sometime after I made the post but before I made the final edit. Please double-check the workbook and formulas.

The biggest adjustment was an accidental double-dip on Weekly OT hours.

Looks like you beat me to the punch Whizbang. Good on ya.

Dawsonsoo, I did want to point out however. Double check your overtime payment calculations. The OT rate should be calculated as "OT hours*1.5" not "OT hours*0.5. By multiplying by 1.5, the employee is receiving time and a half for each OT hour.

You can do it either way

(All hours worked * Rate) + (OT Hours * (Rate * .5))

(Regular Hours * Rate) + (OT Hours * (Rate * 1.5))