Pages

Friday, November 7, 2014

Use the WEEKDAY function to calculate with different hourly pay rates - Date and Time Functions - Microsoft Excel Tutorials

Use the WEEKDAY function to calculate with different hourly pay rates using Microsoft Excel

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
Watch the Video Tutorial - https://www.youtube.com/watch?v=3jg_beNL-LI

 

1 comment:

  1. Hi, If my hourly rate (mon to thus) morning shift $10. how to put in formula?

    ReplyDelete

Submit Site to Google Free Articles Search Engine Submission - AddMe Directories Suggest Link Business Directory AutoBackLinks Directory Bingo Bahia Submission Software Reviews