Myönnetty

project5961

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

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

Näytä lisää: excel spreadsheet formula, hourly employees, data entry morning shift, data entry afternoon shift, employee hours access database, 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, excel formula spreadsheet

About the Employer:
( 1 review ) Matredal, Norway

Projektin tunnus: #1702733

9 freelanceria on tarjonnut keskimäärin 80 $ tähän työhön

pishty

I am interested in your project.

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

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)
3.0
vidhyagp

Hi, Ready to start. Regards, Vidhya G

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

more details

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

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)
0.0
ek189603

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)
0.0
prashantmishra52

fast work with no error and within timeline.

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

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

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

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

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