I can suggest an approach but I don't have ready made code to post.
You could have a table of countries. Each Country record would have a Country name and say go crazy with 20 slots for each of that Country's holidays.
Then you make a relationships where 1 Country has many Claims. (Let call you records "Claims"). Look up the 20 holidays down to the claim. You will also need to snapshot them since as time goes by you will be updating the Holiday dates and not not want to to change historical Claims.
Then, you will need to have a field to count the # of holidays which fall in between your Claims Start and End dates.
It would be a repetitive formula like
Count(
[Claim Start Date]<[Holiday 1 snapshot] and [Claim End Date]>[Holiday 1 snapshot]),
[Claim Start Date]<[Holiday 2 snapshot] and [Claim End Date]>[Holiday 2 snapshot]),
etc
[Claim Start Date]<[Holiday 20 snapshot] and [Claim End Date]>[Holiday 20 snapshot]))
so then you will have the # of days to subtract from your processing time, and you would multiply the # of days times the hours per day (which seems to be 11 hours = 1 day) and subtract that from your formula above.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commarkshnier2@gmail.com
------------------------------
