Discussion Board for collaboration related to QlikView App Development.
I hope all is well.
I need to get the difference between two date fields in hours: minutes that have this format : 'DD/MM/YYYY hh:mm:ss' without counting saturday and sundays. My actual expression :
gives this result :
I need the result in hours knowing that the working hours are from 8h=>18h
so the result would be : 8H44 =>18h + 8h=>10:04
Any idea pleaase
Thanks in advance
May be check this
Business Working Hours Calculation
Thanks for the link, i used the first script
but the result seems wrong. attached is my script (in the first conversation)
Let's see if kush141087 is available to help as he is the one who created the blog. He might be able to resolve this much better then I can.
Thanks for your help.