topic Re. :Hours within period in QlikView

Hours within period

Thu, 24 Mar 2011 14:49:09 GMT

Hi,

I have a series of Time Stamps. Let's call series one Start_Date and series two End_Date. If Start_Date is 17/03/2011 13:00:00 and End_Date is 24/03/2011 13:00:00, I want to calculate the hours between the two dates minus weekend hours. In this example it would be 7 calendar days but only 5 week days. What I'm currently getting is 120 hours. What my aim is, is to get 120 hours - 48 hours (for the weekend) = 72 hours.

Please could someone give me an idea on how to do this.

Thanks,

Shane

Re. :Hours within period

Thu, 24 Mar 2011 15:04:57 GMT

Hi Shane,

you must use the function

NetWorkDays(Start_Date,End_Date)

It returns the number of working days (Monday-Friday) between and including start_date and end_date

Kindly,

Hours within period

Anonymous — Thu, 24 Mar 2011 20:56:40 GMT

Shane,
What is your calculation? Where the 120 hours come from? Maybe it is correct?
7 days is 7x24=168 hours. Subtract 48, and you get the the same 120.

Hours within period

Fri, 25 Mar 2011 08:53:08 GMT

thanks for the responses. I think I can work with Networkdays (with a bit of tweaking). To answer your question Michael, I meant that I would like to get 120 hours instead of 168 but I think that Networkdays could help me. Thanks guys