hi

i am new to this forum

my problem is i have table to define the working hours of the employees based on that i need to calculate the hours

there is no such rule of common shift timeing

>>Problem statements

Have Creation date of ticket

Employee work in diffrent shift based on the World country they support

so weekoff and shift time are in one table

and list of holidays in another table

so now i need to calculate the time spent as of now... received time and current time - i should get the business hours

Table 1 : Shift start Time | Shift End time | Weekoff1 | weekoff2 |

Table 2 : Holidays

Result should be business hours