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

Time interval between two timestamps excluding weekends

Hi guys,

I'm trying to calculation time intervals between startdate and enddate, excluding weekends. Both startdate and enddate are timestamps. I know the function networkdays(), but it only counts days, not precise to timestamps.

 

What function I should use? Thanks in advance!

1 Reply
Marcos_rv
Creator II
Creator II

You could use a calendar and set flags for the weekdays, I would even tell you that you could add the working days. and in the expressions use set analisys with using this flag that you created.

Another one that occurs to me knowing how many days are from Monday to Friday, find a way to add the dedecimals, this represents the time and so you would have the days you need with the hours.

Regards!!!