Calculating Total Pay, Based on Hours Worked Per Day and Hourly Rates

by  About
       

Problem:

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)



Leave a Reply

Your email address will not be published. Required fields are marked *


2 + nine =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>