
Not applicable
2015-05-18
01:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Networking days
Hello Everyone,
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.
Example:
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.
Many Thanks,
Kind Regards
587 Views
1 Reply

MVP
2015-05-18
01:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Go through this thread: Re: Calculate hours between two Date/Time strings Should be helpful for you.
257 Views
