Welcome to WebmasterWorld Guest from 54.145.179.206 register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts, Pubcon Platinum Sponsor 2014
 Home / Forums Index / WebmasterWorld / Professional Webmaster Business Issues
Forum Library, Charter, Moderators: LifeinAsia & httpwebwitch

# Professional Webmaster Business Issues Forum

 Tweet
Excel Timecard Formula help
pmgreen

Msg#: 4196273 posted 9:02 pm on Sep 3, 2010 (gmt 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

LifeinAsia

Msg#: 4196273 posted 9:42 pm on Sep 3, 2010 (gmt 0)

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.

 Global Options: top home search open messages active posts  Tweet

 Home / Forums Index / WebmasterWorld / Professional Webmaster Business Issues

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.