Excel Formula to Calculate Overtime
Pagado a la entrega
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.
Nº del proyecto: #36714198
Sobre el proyecto
119 freelancers están ofertando un promedio de $110 por este trabajo
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.