Discussion board where members can get started with QlikView.
I have start date and end date and want to calculate Total Hours (8 a.m. - 5 p.m., Monday -Friday), excluding weekends.
Start Date End Date
4/27/2009 3:34:56 PM 5/28/2009 6:30:00 PM
How to achieve this.
Have a look at
Calculate hours between two Date/Time strings
Actually I am looking for this ...
Ok, but where is the problem applying the code I have linked to?
if i use your logic for my data then will i get desire output ??