Excel Formula to Calculate Overtime

Completado Publicado hace 3 meses Pagado a la entrega
Completado 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.

Excel Procesamiento de datos Entrada de datos Visual Basic Matemáticas

Nº del proyecto: #36714198

Sobre el proyecto

119 propuestas Proyecto remoto Activo hace 3 meses

Adjudicado a:

(605 comentarios)
8.6

119 freelancers están ofertando un promedio de $110 por este trabajo

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 Más

$180 AUD en 5 días
(606 comentarios)
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 en 1 día
(507 comentarios)
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 Más

$50 AUD en 2 días
(209 comentarios)
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 Más

$40 AUD en 1 día
(229 comentarios)
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 Más

$79 AUD en 1 día
(267 comentarios)
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 Más

$30 AUD en 1 día
(61 comentarios)
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 Más

$80 AUD en 2 días
(28 comentarios)
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 Más

$50 AUD en 1 día
(100 comentarios)
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 Más

$30 AUD en 1 día
(125 comentarios)
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 Más

$100 AUD en 1 día
(133 comentarios)
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 Más

$140 AUD en 1 día
(169 comentarios)
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 Más

$140 AUD en 7 días
(46 comentarios)
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 Más

$30 AUD en 1 día
(55 comentarios)
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 Más

$200 AUD en 4 días
(28 comentarios)
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 Más

$75 AUD en 1 día
(82 comentarios)
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 Más

$50 AUD en 1 día
(38 comentarios)
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 Más

$120 AUD en 7 días
(2 comentarios)
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 Más

$95 AUD en 1 día
(17 comentarios)
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 Más

$140 AUD en 7 días
(41 comentarios)
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 Más

$155 AUD en 2 días
(3 comentarios)
4.6