Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

counting days and time in minutes excluding Weekends??

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.

Tags (1)
3 Replies
Highlighted
Master III
Master III

Re: counting days and time in minutes excluding Weekends??

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

Highlighted

Re: counting days and time in minutes excluding Weekends??

HI,

look at Networkday() function.

Regards

ASHFAQ

Highlighted
MVP
MVP

Re: counting days and time in minutes excluding Weekends??

have a look here for working time

Calculate hours between two Date/Time strings