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…

I think you did not understand me correctly. If there is a clock in time on a public holiday, then only must the 8 hours show in the PPH column and if the employee did not work on the public holiday the 8 hours must still show but not on any other day.

Thanks for the reply,

It works but I also need to get the Public holiday to show even if the employee did not work that day, but thanks for the help so far.

see amended post #4

2nd formula

Sorry it was my mistake, thanks for your help it’s working perfectly now.