Hi Guys,
Sorry to ask again for support. There are great minds on this forum that helped me in a heartbeat in the past and I hope I'll have the same luck this time. I am struggling a bit to figure out the logic on my problem.
In a roster, I'd like to figure out how to count total hours worked on public holidays for the staff. Taking into account the specific shift worked.
In an ideal scenario, the formula will figure if the day worked is a public holiday (PH), if it is what is the shift and the hours corresponding, and sum up all hours worked during those public holidays.
I've attached the excel example, in yellow the outcome I'm seeking. I have one roster with people and 2 tables containing my shift and my public holidays. For the sake of example I put everything on the same sheet.
I'm sure it is an easy fix for some but not for me. Would definitely appreciate a hand on this one.
Thanks,
Fab
Bookmarks