Calculating time to close the case

[#1]

Hey guys,

I attached a file and want to calculate the no of days, hours and minutes took to close the case in different column in qlikview excluding the weekends . And status as "Closed" or "Pending".

The field which is blank will be the today's time and status will be as "Pending".

Ticket No	User	Case Created	Case Closed
1	abc1	19/11/2014 11:45	29/11/2014 12:50
2	abc2	19/11/2014 16:30	19/11/2014 17:18
3	abc3	24/11/2014 11:45	27/11/2014 12:25
4	abc4	19/11/2014 08:30	19/11/2014 11:50
5	abc5	22/11/2014 14:30	24/11/2014 15:30
6	abc6	19/11/2014 19:15
7	abc7	20/11/2014 16:05	20/11/2014 17:00
8	abc8	20/11/2014 16:05	21/11/2014 12:00
9	abc9	27/11/2014 12:30	28/11/2014 11:30

[marcus_sommer]

To exclude the weekends you could use networkdays():

networkdays(floor([Case Created]), floor([Case Closed]))

and then adds the time:

frac([Case Closed]) - frac([Case Created])

- Marcus