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]


Taidot: tiedonsyöttö, tietojenkäsittely, Excel

Näytä lisää: excel spreadsheet formula, hourly employees, data entry at morning shift, data entry afternoon shift, employee hours access database, excel formula spreadsheet spreadsheet, excel clock spreadsheet, access database work hours, employee data access database, employee time database, excel time clock spreadsheet, formula excel work hour, employee time clock day, access clock, access time clock, excel database expert, access database employees, sunday data entry work, extract data excel spreadsheet, expert extract, employee database access, access employee database, spreadsheet time clock, afternoon hours data entry, project employees database

Tietoa työnantajasta:
( 2 arvostelua ) Matredal, Norway

Projektin tunnus: #1702733

9 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


I am interested in your project.

$30 USD 2 päivässä
(53 arvostelua)

Hi, we can write the codes. Please provide us with the access database and any other relevant file you may have, and we can get started right now. Thank you.

$30 USD 1 päivässä
(2 arvostelua)

Hi, Ready to start. Regards, Vidhya G

$30 USD 5 päivässä
(0 arvostelua)

more details

$250 USD 10 päivässä
(0 arvostelua)

I have experience working with formulas in excel. Please provide me the file. Thank you for this project.

$30 USD 3 päivässä
(0 arvostelua)

Already I have a good idea of what it would take to have the report formed to your expectation. It will involve linking the Access table to an excel sheet and then creating a new tab in the excel workbook to make cond Lisää

$117 USD 1 päivässä
(0 arvostelua)

fast work with no error and within timeline.

$101 USD 2 päivässä
(0 arvostelua)

I have experience in computer typing,I am heaving good accuracy

$50 USD 3 päivässä
(0 arvostelua)

Hi, Pleasure to bid on this project. Details are available in your personal message box.

$80 USD 5 päivässä
(0 arvostelua)