Excel Formula to Calculate Overtime
$30-250 AUD
Teslim sırasında ödenir
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.
Proje NO: #36714198
Proje hakkında
Seçilen:
Bu iş için 119 freelancer ortalamada $110 teklif veriyor
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
"""""""""""""""""""""""""""""""""""""""ADVANCE EXCEL FORMULA'S EXPERT"""""""""""""""""""""""""""""""""""""""""""""" ""Sir, I am having 10+ years of Excel experience. EXCEL is my specialty and I can perform any complex Daha Fazla
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 Daha Fazla
Hello Utilizing my expertise in Excel / Google sheets, I will design the Overtime Calculator for you in line with the conditions / logic detailed out on this job description to automatically categorize the Hours worked Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
Dear Client, I have sound knowledge of excel and analytics. Also, I previously carried out several projects in excel using pivot and macro. I ensure you will be happy after hiring me. Kindly contact me. Check my port Daha Fazla
As a section head in the planning and cost control department at a leading company in the Middle East, I specialize in creating reports and analyzing data related to various projects such as sales, cost management, pla Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
