Problem with the time stamps interval

[Anonymous]

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

[lakshmikandh]

Calculate hours between two Date/Time strings

[jonathandienst]

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.