Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Interval between timestamp with no holiday

Hi,

I have log_from and Log_to and I have done an timestamp interval, my problem is the NetWorksdays is one day I want to excluding the time for I have in holiday in my calculation.

Log_From                        Log_to                           Interval                  I want to have

2009-08-21 10:54:16       2009-08-26 13:42:43     05 - 02:48:27       3 - 02:48:27

It log_from is on a Saturday I want to excluding only the time not the all day.

Cheers Viktoria

0 Replies