Fermé

Excel Formula

This is what we have to calculate from a spreadsheet of over 100,000 timeclock entries that are not consistent.

When an employee worked more than 5 hours they have to take a 30 minute break before 5 hours, so I need to know every time an employee worked more than 5 hours, whether they took a 30 minute break and if the break was taken before 5 hours. Also, if they worked more than 10 hours they have to take 2 30 minute breaks.

Then a need to calculate a violation rate for all the times people worked more than 5 hours and didn’t take their full 30 minute break within 5 hours.

Then I need to determine the most favorable violation rate sampling of a percentage (not sure what the percentage is yet maybe 10%) of the total employees.

Compétences : Traitement de Données, Excel, VB.NET

Voir plus : zillow zestimate formula excel, screen scrape formula excel, payment formula excel, capitalised interest formula excel, yield formula excel, tiered pricing formula excel, paste formula excel, call web service formula excel, ranking formula excel lowest number, rank formula excel, excel vba repeat macro times, lowest bid formula excel, formula excel, advertising formula excel, interest payment formula excel

Concernant l'employeur :
( 0 commentaires ) United States

N° du projet : #12736142

40 freelance font une offre moyenne de $52/heure pour ce travail

jaylancer43

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among Plus

$50 USD / heure
(512 Commentaires)
8.0
$55 USD / heure
(254 Commentaires)
7.6
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Plus

$50 USD / heure
(202 Commentaires)
7.2
cugamelover

I can do exactly what you need. I'm a computer science professional with extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scri Plus

$50 USD / heure
(178 Commentaires)
7.0
hdlong66

Hello, I am good at excel and able to write formula for this task. Can you please share your file? Thank you and Best regards, Hoang

$50 USD / heure
(105 Commentaires)
6.7
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega Plus

$50 USD / heure
(179 Commentaires)
6.7
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$55 USD / heure
(210 Commentaires)
6.8
maverick44000

Hi Sir, Being a highly skilled Excel and VBA freelancer I shall be able to complete the task within 4 to 5 hours. Please share the sheet and discuss via chat. Thank you, Usman

$55 USD / heure
(70 Commentaires)
6.7
mrbrave

Hi, I am expert in excel with over 7 years of experience. Using advanced Excel functions and macros, I can complete this very quickly. Please send me sample file with data for review. I am available to work on Plus

$55 USD / heure
(193 Commentaires)
6.5
esalem

Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and Plus

$52 USD / heure
(17 Commentaires)
6.4
wsh2

At your earliest convenience, could you please send a sample copy of your workbook(s) via private chat attachment so we may better analyze and discuss your requirement. Thank you in advance! Greetings from Easton PA Plus

$50 USD / heure
(34 Commentaires)
6.0
ksriniravi

Greetings! I can provide an automation solution for the defined rules either through Macros or Worksheet Formulas. In that case my overall estimate for project complete is USD 80. It need not be 50 USD/hr for 10 hou Plus

$50 USD / heure
(115 Commentaires)
6.2
sergiuloghin

Hello! I am an Excel and Math expert ( check my 100% [url removed, login to view] Math Certification). I am available these days for your project. I can create the formulas easy. Can you send me the spreadsheet so I can have a look? Plus

$55 USD / heure
(115 Commentaires)
6.1
shikhamehta

Hey, I am an expert in data processing using Excel/Python and can evaluate the time card data you have to determine the violations of 'break' rule and other info you need. Can you share some sample data for me to Plus

$66 USD / heure
(91 Commentaires)
6.2
catstevens2009

Hi there! Have done this type of work before and am an excel expert! Please feel free to message me with any additional information or with questions if any! Thanks! -Steve

$50 USD / heure
(80 Commentaires)
5.5
RRconsultant

A proposal has not yet been provided

$50 USD / heure
(30 Commentaires)
5.4
$51 USD / heure
(31 Commentaires)
5.1
abdolah2014

HI I am an excel-vba Expert and I can finish you project so fast pm me to start now ....................................................................................................................

$55 USD / heure
(37 Commentaires)
5.3
abhinovpankaj

Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with vari Plus

$55 USD / heure
(40 Commentaires)
5.4
inspireplatinum

Using Excel and managing data is critical for my job, so am proficient with formulas and additionally can code. Have done several complicated projects involving the cleaning and conversion of raw data, analytics and re Plus

$50 USD / heure
(9 Commentaires)
4.7