Excel Formula

  • Estado Cerrado
  • Presupuesto min $50 USD / hour
  • Total de ofertas 43

Descripción del proyecto

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.

Obtén cotizaciones gratis para un proyecto como este
Habilidades necesarias

¿Buscas ganar algo de dinero?

  • Fija tu plazo y presupuesto
  • Describe tu propuesta
  • Recibes pagos por tu trabajo

Contrata Freelancers que también oferten en este proyecto

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online