Welcome to WebmasterWorld Guest from 54.205.74.11

Forum Moderators: LifeinAsia & httpwebwitch

Excel Timecard Formula help

   
9:02 pm on Sep 3, 2010 (gmt 0)

5+ Year Member



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
9:42 pm on Sep 3, 2010 (gmt 0)

WebmasterWorld Administrator lifeinasia is a WebmasterWorld Top Contributor of All Time 5+ Year Member Top Contributors Of The Month



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.
 

Featured Threads

My Threads

Hot Threads This Week

Hot Threads This Month