Closed

project5961

This project received 9 bids from talented freelancers with an average bid price of $80 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Total Bids
9
Project Description

Hi, i have a project for an experienced Excel Formula expert. i have a time keeping spreadsheet that has 2 places were employees can clock in and clockout. in other words they clock in at the beginning of the day and clockout for their break they clock back in for the afternoon shift and clockout at the end of the day.

Part 1) the time is entered into a MS Access database and needs to imported into the excel spreadsheet.
part 2) each employee gets an hourly bonus based on the following criteria
if they work after 19:00 a $1 bonus per hour
if they work after 21:00 a $2 bonus per hour
if they work Friday after 21:00 a $2,5 bonus per hour
if they work Sunday starting at 00:00 a $3 bonus per hour
if their hours fall on a public holiday they get 100%
if they work more than 7,5 hours per day they get 50%

the important part is that the formula can extract this info from the time entered into A{time in morning} B {time out morning] C[time in afternoon] D[time out afternoon]
thanks

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

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