Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Geniuses,
I have two time stamps
Open_Timestamp --> When the ticket opens
Close_Timestamp --> When the ticket closes
I want to find out that how much hours it took to close the ticket, I have to exclude the Friday and Saturday of the week from the calculation(As friday sat is weekend here )
Please help me.
Thanks in advance.
S
Unfortunately, the working day calculations in QV have a fixed weekend of Saturday and Sunday, so you will have to roll your own.
What I would do is include a working day as a field in your calendar, having a value of zero for Fridays and Saturdays and 1 for working days. You could then sum working days to get a NetWorkDay equivalent that you could then plug into the suggestions in the link above.