Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MVP
MVP

Creator II
Creator II

Hi swuehl‌,

Actually I am looking for this ...

PFA

MVP
MVP

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

Creator II
Creator II

swuehl

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

Thanks