Exclude Specific Hours in weekends - Time Calculation

[Anonymous]

Dear Experts,

Kindly refer the attachment.

I want to calculate the time taken for the process flow.ie.Time taken from "In Queue" to "Complete".But here I want to exclude the hours from Friday 7PM to Monday 8AM.

I tried the networkdays,but it is not giving the expected answer since I need specific hours only.

Could you please help me

Thanks & Regards

Jeba

[Anonymous]

Hi Tresesco,

Yes,I almost got the logic and thanks a lot for your patience and guidance.

This is working based on specific hours during all working days,however the requestor asked me to ignore only the specific weekend hours not all working days.

Now I have suggested the requestor to calculate only the office hours.I am waiting for their confirmation.

Mean while if you find anything interesting to exclude only the specific weekend hours kindly message me.

Again thanks a lot for your timely help.

Thanks & Regards

Jeba

[#3]

Hi,

Then its very difficult to find the logic,

I tried it and I can't figure out the logic,

wait for the Experts reply .