Excel Formula

Cerrado

Descripción

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

ID de proyecto: #12736142

43 freelancers están ofertando un promedio de $52 /hora para este trabajo.

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

$50 USD / hora
(387 comentarios)
7.7
$55 USD / hora
(249 comentarios)
7.6
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 / hora
(67 comentarios)
6.6
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 Más

$50 USD / hora
(165 comentarios)
6.6
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 / hora
(126 comentarios)
6.4
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 Más

$52 USD / hora
(17 comentarios)
6.4
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 / hora
(79 comentarios)
6.5
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 Más

$50 USD / hora
(142 comentarios)
6.8
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 Más

$66 USD / hora
(90 comentarios)
6.2
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 Más

$55 USD / hora
(179 comentarios)
6.3
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 Más

$50 USD / hora
(91 comentarios)
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 Más

$50 USD / hora
(30 comentarios)
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 / hora
(71 comentarios)
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 Más

$55 USD / hora
(36 comentarios)
5.3
sergiuloghin

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
(54 comentarios)
5.2
abdolah2014

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

$55 USD / hora
(30 comentarios)
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 Más

$50 USD / hora
(39 comentarios)
5.0
$50 USD / hora
(19 comentarios)
4.2
RRconsultant

A proposal has not yet been provided

$50 USD / hora
(13 comentarios)
4.9
$51 USD / hora
(21 comentarios)
4.4