Đã Trao

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

Kỹ năng: Nhập liệu, Xử lí dữ liệu, Excel

Xem thêm: 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

Về Bên Thuê:
( 2 nhận xét ) Matredal, Norway

Mã Dự Án: #1702733

9 freelancer đang chào giá trung bình $80 cho công việc này

pishty

I am interested in your project.

$30 USD trong 2 ngày
(53 Đánh Giá)
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 trong 1 ngày
(2 Đánh Giá)
3.0
vidhyagp

Hi, Ready to start. Regards, Vidhya G

$30 USD trong 5 ngày
(0 Đánh Giá)
0.0
bpojob2020

more details

$250 USD trong 10 ngày
(0 Đánh Giá)
0.0
arval21

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

$30 USD trong 3 ngày
(0 Đánh Giá)
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 Thêm

$117 USD trong 1 ngày
(0 Đánh Giá)
0.0
prashantmishra52

fast work with no error and within timeline.

$101 USD trong 2 ngày
(0 Đánh Giá)
0.0
ireshanipeiris

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

$50 USD trong 3 ngày
(0 Đánh Giá)
0.0
KRKans

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

$80 USD trong 5 ngày
(0 Đánh Giá)
0.0