To do this we can use the WEEKDAY function. So before we can look up the rate we need to know how to calculate the day of the week that they started their shift. The rate for starting work on a Saturday or Sunday is higher than the other days of the week.
In the day and night lookup tables, the rate of pay is determined by the day of the week that they worked. Range Names have been assigned to each table. The second column stores the rate of pay. The first column is the day of the week represented as a number, where 1 is Monday and 7 is Sunday. One for day shifts and the other for nights. To include this, 2 lookup tables were set up on a different sheet.
In addition to the type of shift worked, the day of the week if also a factor in determining the rate of pay applied. The IF function first tests if it was a night shift, then test to see if it was worked overnight (A5 A column (column E) is also used to record whether it is a day or night shift. This will make it easier for our calculations. In this timesheet, the day and night shifts are entered on separate rows. Excel Timesheet with Different Rates for Shift Work Calculating Hours Worked
0 kommentar(er)
