Hi
I would like to calculate the difference between 2 date-time, by excluding bank holidays and weekends. Example
below:
11/14/2014 11:00:10 AM
11/20/2014 13:42:30 PM
Consider 11/15/2014 and 11/16/2014 as weekend and 11/18/2014 as a holiday.
Means the difference between the two should be 3 days 2 hours 42 minutes and 20 seconds. Actually, I need to calculate it in terms of seconds (3*24*60*60) + (2*60*60) + (42*60) + 20 = 268940 seconds and then reconvert it into days = 268940/86400 = 3.11 days
I would like to know if there is a way to do this calculation the qlikview script.
Thanks
Hasnaa
