Working hours only

[#1]

Hi All,

I have to 2 timestamp fields Start Date and Closed Date. I want to calculate the time it takes from start date to close date.

i only want to include times between 8am and 6 pm and not including saturdays and sundays.

for example.

Start date is 30/10/2012 15:00:00 and Closed Date is 31/10/2012 10:00:00 i would expect the calculated to bring back 5 hours as the cycle time.

Can anyone help me work out how to do this calculation in Qlikview?

Thanks

Laura

[Claudiu_Anghelescu]

How to proceed if I have vStartHour=5, vEndHour=2 ?

[SergioTres]

This is Optimun Stephan,

thanks

[Saro_2306]

Hi swuehl,

Can you please advise to rewrite above formule for Working Hour Starts from 6pm to next day 3am and if Weekends are Friday and Saturday.

Thanks in Advance. 

[Saro_2306]

Hi, Did you get solution for your query.

Am also having same problem. Could please help me if you have solution.

Thanks in Advance.

[Claudiu_Anghelescu]

I think it’s not possible to adapt the existing script to your needs. I did it in the past writing many many IF lines using also the original script.