Welcome to WebmasterWorld Guest from 54.221.54.252

Forum Moderators: LifeinAsia & httpwebwitch

Message Too Old, No Replies

Excel Timecard Formula help

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

Junior Member

5+ Year Member

joined:May 15, 2007
posts: 57
votes: 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
9:42 pm on Sept 3, 2010 (gmt 0)

Moderator This Forum from US 

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

joined:Dec 10, 2005
posts:5627
votes: 47


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.
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members