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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Networking Days issue

Hi,

I have 2 timestamps and i need the time difference(in HH:MM format) between those 2 timestamps excluding Saturday,Sunday(NetworkingDays), how can i do this?

please find the attachment.

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Something like: interval(networkdays(StartDate,EndDate)+frac(EndDate)-frac(StartDate),'hh:mm')


talk is cheap, supply exceeds demand