Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

vijayptcs
Contributor II

Calculate Total Hours

Hi All,

I have start date and end date and want to calculate Total Hours (8 a.m. - 5 p.m., Monday -Friday), excluding weekends.

Start Date                                    End Date

4/27/2009  3:34:56 PM               5/28/2009 6:30:00 PM

How to achieve this.

4 Replies
Highlighted
MVP
MVP

Re: Calculate Total Hours

vijayptcs
Contributor II

Re: Calculate Total Hours

Hi swuehl‌,

Actually I am looking for this ...

PFA

MVP
MVP

Re: Calculate Total Hours

Ok, but where is the problem applying the code I have linked to?

vijayptcs
Contributor II

Re: Calculate Total Hours

swuehl

if i use your logic for my data then will i get desire output ??

Thanks