Thread: Can an Excel time sheet determine if a day is a holiday and calculate hours worked?

Hi,

We've recently changed the method by which we track our hours worked here where I am employed. I've created an Excel-based time sheet for our use at work to help keep the paperwork looking neat and help us in tracking this. It worked great until the recent holidays when a particular shortcoming was illustrated. On my supervisor's payroll sheet with which he keeps track of the types of hours we've worked and which he submits to our payroll department, it has cells indicating "holiday hours worked" and "holiday hours not worked". The one which I've created does not; this requires him to determine how many hours of each type an employee may have accrued over a pay period. He's asked that I modify the time sheet to include any hours someone may have worked at the higher Holiday Worked rate and an entry for hours someone may accrue through holidays in which they receive paid time off.

What I need (and I'm not even sure if it's possible) is for the time sheet to check if a given date is one of our recognized holidays for which we'd be paid at a higher rate if we've actually worked it. Based on whether or not a given date is one of those holidays, it would calculate the hours worked and input that number in the proper cell (whether it be Regular Hours or Holiday (Worked)).

Is this possible and, if so, can someone show me how it's done?

I've attached a copy of the original sheet and the re-designed look I created to try to include the information he requires.

That works great! Thanks for your help.