| Welcome to WebmasterWorld Guest from 22.214.171.124 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Pubcon Platinum Sponsor 2014|
|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 is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved