| Welcome to WebmasterWorld Guest from 188.8.131.52 |
register, login, search, subscribe, help, library, PubCon, announcements, recent posts, open posts,
|Accredited PayPal World Seller|
|Excel Timecard Formula help|
| 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
| 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 you want to combine everything in one column to get the actual pay, then just multiple the numbers by the base pay.
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld ® and PubCon ® are a Registered Trademarks of Pubcon Inc.
© Pubcon Inc. 1996-2012 all rights reserved