Use the WEEKDAY function to calculate with different hourly pay rates using Microsoft Excel
To calculate with different hourly pay rates:
1. In a worksheet, enter the data shown in columns A, B, and C in Figure.
2. Select cell F2 and enter 12.50 (hourly rate for Monday through Friday).
3. Select cell F5 and enter 18.50 (hourly rate for Saturday and Sunday).
4. Select cells D2:D10 and type the following formula:
=IF(OR(WEEKDAY(A2)=1,WEEKDAY(A2)=7),C2*$F$5,C2*$F$2).
5. Press <-Ctrl+Enter->.
Watch the Video Tutorial - https://www.youtube.com/watch?v=3jg_beNL-LI
Many companies calculate payroll using hourly rates for each employee. The hourly rates depend on which days are worked, as work performed on the weekend often is paid at a higher rate than work performed Monday through Friday.
In this example, different hourly rates are defined based on which days are worked. Column A lists the dates, column B has the custom format DDD to show the day of the week, and column C lists the number of hours worked.
To calculate with different hourly pay rates:
1. In a worksheet, enter the data shown in columns A, B, and C in Figure.
2. Select cell F2 and enter 12.50 (hourly rate for Monday through Friday).
3. Select cell F5 and enter 18.50 (hourly rate for Saturday and Sunday).
4. Select cells D2:D10 and type the following formula:
=IF(OR(WEEKDAY(A2)=1,WEEKDAY(A2)=7),C2*$F$5,C2*$F$2).
5. Press <-Ctrl+Enter->.
Use the WEEKDAY function to calculate with different hourly pay rates |
Hi, If my hourly rate (mon to thus) morning shift $10. how to put in formula?
ReplyDelete