Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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