Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Luisanabria
Creator
Creator

Calculate work hours between 2 dates

Hi Community,

l wonder how can l calculated the hours (or minuts) between 2 dates considering a schedule 8am-6pm, excluding saturday, sunday and special days of no work. 

This is and example of my fields on Excel, l calculated there but l would like to learn how to do it here if possible:

Date StartServ Date EndServ
25/05/2022 11:26:20 a. m. 25/05/2022 12:38:33 p. m.
23/05/2022 12:20:20 p. m. 10/06/2022 02:24:34 p. m.

 

This because after get the hours, l will use a condition of that result

Thanks!

 

1 Reply
justISO
Specialist
Specialist

Hi, there are multiple forum questions with similar question, please try to use search and I'm sure youll find your answer. For example:

https://community.qlik.com/t5/QlikView-Documents/Working-Hours-Calculation-excluding-weekends-and-ho...

or

https://community.qlik.com/t5/QlikView-App-Dev/Working-hours-calc-between-dates/td-p/1110348