I have an assignment where I need to calculate the time (days, hours, miniutes) it has taken to complete an order. The calculation needs to exclude working days and holidays which flucuate by country.
I have the country, start (date/time) and end (date/itme) fields for the calculation and also tables with dates of country specific holidays and a table for country specific working days.
I've seen other solutions provided on this site for calculating time between dates but not sure how to incorporate the international aspect of this task into a solution.
I need to complete this task very quickly so any and all assistance is greatly appreciated.