Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-05-18 01:08 AM

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

656 Views
0 Likes
1 Reply
tresesco
MVP
MVP
‎2015-05-18 01:35 AM

Go through this thread: Re: Calculate hours between two Date/Time strings Should be helpful for you.

326 Views
0 Likes