Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi, there are multiple forum questions with similar question, please try to use search and I'm sure youll find your answer. For example:
or
https://community.qlik.com/t5/QlikView-App-Dev/Working-hours-calc-between-dates/td-p/1110348