» Calculating Total Pay, Based on Hours Worked Per Day and Hourly Rates
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Listed in columns A & B are the times an employee signed in and out of work each day.
Column C contains the rate per hour for that particular day.
We want to calculate the employee's total pay.
Solution 1:
To calculate the number of hours worked per day, enter the following formula in column D:
=B2-A2+(A2>B2)
Then calculate the pay per day by entering the following formula in column E:
=C2*D2*24
Finally, use the SUM function as shown in the following formula to sum the results from column E:
=SUM(E2:E7)
Book Store:
Recommended Books:
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Financial Peace: Revisited
- Special Edition Using Microsoft Access 2002
- Definitive Guide to Excel VBA
Re: Calculating Total Pay, Based on Hours Worked Per Day and Hourly Rates
Uaddup
Alternatevely, you can also downlaod [URL="http://www.calculatehours.com/freetimesheet.html"]free excel timesheets[/URL] from [URL="http://www.calculatehours.com/"]CalculateHours.com[/URL]
