Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

Anonymous
Not applicable
Author

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?

Anonymous
Not applicable
Author

swuehl

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

Thanks