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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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