Cerrado

Excel Formula

Este proyecto recibió 43 ofertas de freelancers talentosos con una oferta promedio de $52 USD / hour.

Obtén cotizaciones gratis para un proyecto como este
Empleador trabajando
Presupuesto de Proyecto
min $50 USD / hour
Ofertas Totales
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.

Buscando hacer algo de dinero?

  • Establece tu presupuesto y período de tiempo
  • Describe tu propuesta
  • Consigue pago por tu trabajo

Contrata Freelancers que también oferten en este proyecto

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