Excel Formula to Calculate Overtime

Đã hoàn thành Đã đăng vào 3 tháng trước Thanh toán khi bàn giao
Đã hoàn thành 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.

Excel Xử lí dữ liệu Nhập liệu Visual Basic Toán học

ID dự án: #36714198

Về dự án

119 đề xuất Dự án từ xa 3 tháng trước đang mở

Được trao cho:

(605 Đánh Giá)
8.6

119 freelancer chào giá trung bình$110 cho công việc này

schoudhary1553

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 Thêm

$180 AUD trong 5 ngày
(606 Nhận xét)
8.5
P0L

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.

$80 AUD trong 1 ngày
(507 Nhận xét)
8.0
deepbluetech

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 Thêm

$50 AUD trong 2 ngày
(209 Nhận xét)
7.4
daniyal3214

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 Thêm

$40 AUD trong 1 ngày
(229 Nhận xét)
7.3
AccountantArman

"""""""""""""""""""""""""""""""""""""""ADVANCE EXCEL FORMULA'S EXPERT"""""""""""""""""""""""""""""""""""""""""""""" ""Sir, I am having 10+ years of Excel experience. EXCEL is my specialty and I can perform any complex Thêm

$79 AUD trong 1 ngày
(267 Nhận xét)
7.2
Giovanni704

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 Thêm

$30 AUD trong 1 ngày
(61 Nhận xét)
7.0
dfexcel

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 Thêm

$80 AUD trong 2 ngày
(28 Nhận xét)
6.8
hamidr2020

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 Thêm

$50 AUD trong 1 ngày
(100 Nhận xét)
6.2
professional800

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 Thêm

$30 AUD trong 1 ngày
(125 Nhận xét)
6.0
WelcomeClient

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 Thêm

$100 AUD trong 1 ngày
(133 Nhận xét)
6.0
merinsinha

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 Thêm

$140 AUD trong 1 ngày
(169 Nhận xét)
5.9
SIBTEHASSANBUTT

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 Thêm

$140 AUD trong 7 ngày
(46 Nhận xét)
5.0
freelancerabdu34

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 Thêm

$30 AUD trong 1 ngày
(55 Nhận xét)
5.0
amokhtar70

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 Thêm

$200 AUD trong 4 ngày
(28 Nhận xét)
5.0
lotusvijay

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 Thêm

$75 AUD trong 1 ngày
(82 Nhận xét)
5.1
mhgroup21

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 Thêm

$50 AUD trong 1 ngày
(38 Nhận xét)
5.0
MagedAtya

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 Thêm

$120 AUD trong 7 ngày
(2 Nhận xét)
5.1
faisal9263

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 Thêm

$95 AUD trong 1 ngày
(17 Nhận xét)
4.7
AnuradhaVM

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 Thêm

$140 AUD trong 7 ngày
(41 Nhận xét)
4.8
mwikalicarolyne2

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 Thêm

$155 AUD trong 2 ngày
(3 Nhận xét)
4.6