Welcome to WebmasterWorld Guest from 23.23.62.93

Forum Moderators: LifeinAsia & httpwebwitch

Message Too Old, No Replies

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

Hot Threads This Week

Hot Threads This Month