Excel Formula to Calculate Overtime
$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.
ID проекта: #36714198
О проекте
Поручен:
119 фрилансеров(-а) готовы выполнить эту работу в среднем за $110
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look Больше
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.
Hi, I have over 10 years of experience in dealing with Excel automation projects. Have been through the requirements and I can deliver the formulas within a couple of days. Please share any sample data for testing the Больше
Hello, Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Auto Больше
"""""""""""""""""""""""""""""""""""""""ADVANCE EXCEL FORMULA'S EXPERT"""""""""""""""""""""""""""""""""""""""""""""" ""Sir, I am having 10+ years of Excel experience. EXCEL is my specialty and I can perform any complex Больше
Hi there! As I have read, I see you need help creating an excel formula to calculate overtime and I could help you! I'm a professional Database Administrator and Analytics Engineer with more than 10 years of experien Больше
Hello, I am an Excel and VBA/Macro expert. I have already completed a similar project (see link below). I have checked the detail and example. https://www.freelancer.com/contest/excel-factuur-2157638 You can check m Больше
I am a professional freelancer that has extensive experience in using Excel formulas to calculate overtime. After reviewing your project description, I believe that I am the best fit for your needs because of my expert Больше
Hi There, Ready right now, Understood.I Will complete it within next 1 hour I'm ready to make Excel Formula to Calculate Overtime. I will show you sample for your satisfaction and project accuracy then we will go to Больше
Excel complex formula expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are a Больше
With over 7 years of experience in excel usage and an ACCA qualification, I have expertise in all areas of Excel, I can provide you with efficient, accurate, and insightful solutions to your data-related challenges. My Больше
Greetings, I am an Advanced Level Excel Formula, VBA & Macros expert and an Accountant. I am very confident to start your project and complete it with all efficiency you are looking for. I understand the requirements a Больше
Hi, I have gone through the Job details and am interested in taking it up. I need you to share more details with me, and I will deliver the required tasks fast and accurately. We will negotiate my fees depending on how Больше
Hello, my name is VIJAYA KUMAR and I am a full-time freelancer. I have extensive experience in Excel formulas and functions, as well as the ability to create formulas to calculate overtime. With my extensive knowledge Больше
Hi, I am happy to submit my proposal for the creation of an Excel formula that will accurately calculate overtime for your work schedule. With my advanced knowledge of Excel formulas and functions, experience in desig Больше
Hello, I have Power and Excel/Google Sheets skills and am able to provide solutions to most Excel/google sheet problems, including VBA programming. If you work with me you will get good value for your money and a flexi Больше
Hello! I am the right person to help you complete this project. I am a professional|expert in Data Entry, Mathematics, Visual Basic, Excel and Data Processing. My years of experience dealing with related projects to y Больше
