PPH day’s calculation on a time sheet.

Good day to all,

Okay I have created a timesheet for the employees, what I need now is that on the first tab you will see I entered the month as the name “3.16” and you will see there is a column that is named “PPH” I want excel to add 8 hours automatically if the employee worked that day and if not the cell must remain blank.

You will see there is a second tab named “Calendar” you will see there is a calendar for the month and then there is a list of the Public Holidays (PPH).

I have attaches screen shots and the document itself.

Thanks for the help in advance…