Excel Formula to Calculate Overtime

Job ID: 36714198

Budget: $30 – $250 AUD

I am looking for a freelancer who can create an Excel formula to calculate overtime for my work schedule. My regular work schedule is not fixed, but the regular hours are 7.6hour days, 5 days a week. I need the formula to account for daily overtime. The formula needs to break up the total hours into Normal, Time 1.5 & Time 2. Where anything between 0-7.6hrs is entered in 'Normal' cell, anything between 7.6-10.6 to be entered in 'Time 1.5' cell and anything over 10.6 is to be entered in 'Time 2' cell. And any Saturday hours worked, the first 3 hours = 1.5 time and anything thereafter equals double time.

Ideal Skills and Experience:
- Advanced knowledge of Excel formulas and functions
- Experience creating formulas for calculating overtime
- Attention to detail to ensure accuracy of the formula
- Ability to communicate effectively to ensure the formula meets my requirements.

See example attachment.