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

How to calculate time between two days if I have to pick weekend time also but time range is diff

Hi 

I want to calculate hours between two dates like below

    1- Calculate hours between two dates only for week dates in between 7 AM to 11 PM 

    2- Calculate hours only for Saterday and Sunday in between 10 AM to 4 PM 

for example - if satrt time = 25-8-2019 8:10

                                 End Time = 27-8-2019 

then Total time = 6 hours for 25-08 as its Sunday + 18.12 hours for Monday(26-08) and Tuesday(27-08)

how can i achieve that

0 Replies