Excel Formula to Calculate Overtime
S-au achitat serviciile după ce au fost prestate
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 Proiect: #36714198
Detalii despre proiect
119 freelanceri plasează o ofertă medie de 110$ pentru proiect
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 Mai multe
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 Mai multe
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 Mai multe
"""""""""""""""""""""""""""""""""""""""ADVANCE EXCEL FORMULA'S EXPERT"""""""""""""""""""""""""""""""""""""""""""""" ""Sir, I am having 10+ years of Excel experience. EXCEL is my specialty and I can perform any complex Mai multe
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 Mai multe
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 Mai multe
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 Mai multe
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 Mai multe
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 Mai multe
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 Mai multe
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 Mai multe
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 Mai multe
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 Mai multe
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 Mai multe
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 Mai multe
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 Mai multe
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 Mai multe
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 Mai multe
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 Mai multe