Discussion Board for collaboration related to Creating Analytics for QlikView.
I badly need some help. I need to find the total time a ticket was open.
Note that the working hours of the company is 08:00 to 18:00 and from Monday to Friday.
I need qlikview to consider a working day as 10 hours instead of 24 hours.
Ticket Opening Date Closing date
TicketA 30/01/2015 15:01:31 04/02/2015 17:03:35
Do you guys have a magical formula to help me.
I tried everything on excel and qlikview but I can't find a way out.
I need to submit that report today.
Go through this thread: Re: Calculate hours between two Date/Time strings Should be helpful for you.