Work Week Calendar!

[cap.zadi]

Hi

I need help to build up a simple calendar (no appointments) to assign working days to employees or Public holidays to all.

Regards

[CJ_London]

broad question, so a broad answer. Also, need to clarify why you need to identify public holidays if you are assigning workdays - just don't assign a workday on a public holiday.

Suggest you need a table something like

tblWorkCalendar
CalPK autonumber
CalDate Date
EmployeeFK long


For days that are public holidays, assign 0 to EmployeeFK - then you can have code that prevents an employee being assigned a public holiday as a workday

[cap.zadi]

Hi

Thanks for ur broad feedback.

Actually the purpose to assign the holidays like Sunday is day off here and some employees have Saturday too in routine and plus can have holidays which needed for the purpose to calculate the Over time.

If the Employee worked from 07:00 - 19:00 ( 8 Regular Duty + 4 Hours OT) and on holiday it should be full as OT.

Thanks

[CJ_London]

not sure if you are asking a question - your original question was about assigning working days. Your last post is more about posting time actually spent

[cap.zadi]

Hello

I am sorry if cant make you understanding as i am not professional like you.

The purpose to explain about timings, etc to let you know why need to assign the work days or holidays to employees or group of employees.

Any help is appreciated.

regards

[CJ_London]

in that case modify the table I suggested to something like


tblWorkCalendar
CalPK autonumber
CalDate Date
EmployeeFK long
Assigned text? e.g. Work/Holiday/Sick