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