Excel Formula to Calculate Overtime
Thanh toán khi bàn giao
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.
ID dự án: #36714198
Về dự án
Được trao cho:
119 freelancer chào giá trung bình$110 cho công việc này
Hello, I am an Excel expert and I would like to help you with your overtime formulas. Please check my profile and contact me to discuss further details. Regards.