| Excel Timecard Formula help
|
pmgreen
msg:4196275 | 9:02 pm on Sep 3, 2010 (gmt 0) |
Trying to create a formula to calculate OT for employees that work over 8 hours a day. They pay is 1.5 of their regular rate. Stuck trying to create the formula.
if column $E$12 is great than 8, take the difference times 1.5 of column I (rate)
Any help would be much appreciated
|
LifeinAsia
msg:4196290 | 9:42 pm on Sep 3, 2010 (gmt 0) |
My Excel skills are pretty rusty, but I seem to remember that something like the following to get the number of hours to multiple by the base rate:
=IF($E$12<=8,$E$12,8+($E$12-8)*1.5)
If you want to combine everything in one column to get the actual pay, then just multiple the numbers by the base pay.
|
|
|
