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