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.
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?
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.