Excel 2010-2019 Excel 2007 Excel 2003 Tips & Tricks Excel Forum Course Index CIG Excel Book

 Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

Overtime Pay
Calculating overtime pay for employees in Excel

 Q: I have a simple employee time sheet showing how many hours each employee has worked this week. How can I calculate the correct amount to pay them if I have to figure in overtime pay? If the employee works up to 40 hours, they get their normal pay rate. From 40 to 50 hours is time-and-a-half, and over 50 hours is double-time. A: You can use some simple calculations and IF functions to figure this out. For example, in the sheet below, to calculate how many "normal" hours (40 and under) you can say: =IF(I2<=40,I2,40) Here is a FREE video tutorial that shows you how to set this sheet up step-by-step:

By Richard Rost

 Check out these other pages that may be of interest to you:
 2/3/2023 TextSplit 1/27/2023 Math in Fields 12/12/2022 Tax Brackets 12/9/2022 Double Lookup 10/24/2022 Follow Hyperlink 9/17/2022 Very Hidden 8/11/2022 Crosstab 8/10/2022 Transpose 7/26/2022 Lottery Numbers 2 7/22/2022 Lottery Numbers