How to create report calculating hours worked on holidays

I am having trouble creating a report that will calculate the hours worked on a holiday (for each user). In a "Timesheet Day" template report, I have created a custom column with the following formula:IF(IsNull(TimeOffTypeName)=1,0,IF(TimeOffTypeName="Holiday",IF(IsNull(HoursWorked)=1,0,HoursWorked),0))However, this does not work. I think because when our employees record their worked hours on a holiday, it is booked in a separate entry from the holiday hours on the same date. Therefore, HoursWorked is always 0 for the holiday entry (while there are still HoursWorked on a separate entry for the same date.)Thank you for any guidance.