Working hours for half-day holiday

For half-day holiday, the business hours are of two types:

However, Mid-day Break hours are excluded while calculating the actual working hours.

For the first-half holiday, working hours are calculated as:

(Regular End Time - Half-day Start Time) minus (Mid-day Break End Time - Mid-day Break Start Time)

which works out to be (Regular End Time - Mid-day Break End Time)

For the second-half holiday, working hours are calculated as:

(Half-day End Time - Regular Start Time) minus (Mid-day Break End Time - Mid-day Break Start Time)

which works out to be (Mid-day Break Start Time - Regular Start Time)

Consider a calendar with:

The Table 3 illustrates the use of Mid-day Break hours.