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.

Habilidades: Procesamiento de datos, Excel, VB.NET

Ver más: 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

Información del empleador:
( 0 comentarios ) United States

Nº del proyecto: #12736142

40 freelancers están ofertando el promedio de $52/hora para este trabajo


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

$50 USD / hora
(512 comentarios)
$55 USD / hora
(254 comentarios)

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

$50 USD / hora
(202 comentarios)

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

$50 USD / hora
(178 comentarios)

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 / hora
(105 comentarios)

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

$50 USD / hora
(179 comentarios)

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 / hora
(210 comentarios)

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 / hora
(70 comentarios)

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

$55 USD / hora
(193 comentarios)

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

$52 USD / hora
(17 comentarios)

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

$50 USD / hora
(34 comentarios)

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

$50 USD / hora
(115 comentarios)

Hello! I am an Excel and Math expert ( check my 100% freelancer.com 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? Más

$55 USD / hora
(115 comentarios)

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

$66 USD / hora
(91 comentarios)

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 / hora
(80 comentarios)

A proposal has not yet been provided

$50 USD / hora
(30 comentarios)
$51 USD / hora
(31 comentarios)

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

$55 USD / hora
(37 comentarios)

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

$55 USD / hora
(40 comentarios)

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

$50 USD / hora
(9 comentarios)