| Welcome to WebmasterWorld Guest from 18.104.22.168 |
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
|Subscribe to WebmasterWorld|
|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.
© Webmaster World 1996-2014 all rights reserved