» Calculating Daily Pay, Incorporating Variable Hourly Rates
Columns B & C contain the times signed in and out of work for each date in column A.
Column D contains the following formula, which calculates the number of worked hours per day:
Range A11:B12 contains 2 types of hourly rates - one for weekdays and one for weekends.
In addition, for both of those types there is an overtime rate (cells C11:C12), which is paid for every hour over 8 daily hours.
We want to calculate the daily pay for each of the dates listed in column A.
Use the WEEKDAY, MAX, and MIN functions as shown in the following formula: