Welcome to WebmasterWorld Guest from

Forum Moderators: LifeinAsia

Message Too Old, No Replies

Excel Timecard Formula help

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

Junior Member

10+ 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
votes: 88

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 you want to combine everything in one column to get the actual pay, then just multiple the numbers by the base pay.