Discussion board where members can get started with QlikView.
I am new to qlikview.
Can you please tell me how to count the no. of working days excluding the weekends.?
And also to calculate the working time in minutes as per 8hr/days.
Networkdays(Start_Dt,End_dt) - Returns no of working days between Start_Dt and End_Dt excluding weekends
Networkdays(Start_Dt,End_dt) * 8 * 60 -- Working time in minutes
look at Networkday() function.
have a look here for working time
Calculate hours between two Date/Time strings