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

42 freelances ont fait 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
(387 Commentaires)
7.7
55 $ USD / heure
(249 Commentaires)
7.6
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
(79 Commentaires)
6.5
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
(67 Commentaires)
6.6
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
(142 Commentaires)
6.8
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
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
(165 Commentaires)
6.6
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
(179 Commentaires)
6.3
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
(90 Commentaires)
6.2
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
(126 Commentaires)
6.4
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
(91 Commentaires)
5.9
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
(30 Commentaires)
5.8
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
(71 Commentaires)
5.4
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
(36 Commentaires)
5.3
abdolah2014

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

55 $ USD / heure
(30 Commentaires)
5.1
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
(39 Commentaires)
5.0
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
(54 Commentaires)
5.2
51 $ USD / heure
(21 Commentaires)
4.4
50 $ USD / heure
(19 Commentaires)
4.2
RRconsultant

A proposal has not yet been provided

50 $ USD / heure
(13 Commentaires)
4.9