Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
vijayptcs
Creator II
Creator 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
swuehl
MVP
MVP

vijayptcs
Creator II
Creator II

Hi swuehl‌,

Actually I am looking for this ...

PFA

swuehl
MVP
MVP

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

vijayptcs
Creator II
Creator II

swuehl

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

Thanks