counting days and time in minutes excluding Weekends??

[#1]

Hey guys,

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.

[anbu1984]

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

[ashfaq_haseeb]

HI,

look at Networkday() function.

Regards

ASHFAQ

[maxgro]

have a look here for working time

Calculate hours between two Date/Time strings