Fast formula: calculate total hours/day, excluding hours booked on Public Holidays

Summary:

Validations hours worked/ day

Content (please ensure you mask any confidential information):

Hi,

We need to validate the total number of working hours for each day of the week.

From this total, we need to exclude the total hours booked on public holiday codes : ex: on a day, we may have both hours booked on public holidays AND worked hours. We need total of worked hours only.

Any idea how to achieve this? What functions/DBIs we can use and how to iterate time entries?

Thank you very much,

Elena

Version (include the version you are using, if applicable):