How to exclude weekend and holidays while calculating duration between two dates?

[Fathima6]

Hi folks,

I am having two date time field

Date time field1 : Assess (July 1, 2023 9 am IST)
Date time field2 : Current date time (july 24 , 2023 12 pm IST)

I want to get duration between these two dates and have to save in another field called Work processed time(duration field).
User datediff I am getting duration but this included weekend and US hoildays. How can I achieve excluding weekend and US hoildays.

@Chuck Tomasi 

Thanks in advance.

[Samaksh Wani]

Hello @Fathima6 

You can do similar to the below screenshot for excluding weekend  in Schdedule Entry :-

For US holidays you can create schedule of holidays and add it in child schedule and select type as include.

Plz Mark my Solution as Accept and Give me thumbs up, if you find it Helpful.

Regards,

Samaksh

[Fathima6]

I am sorry, I am not asking how to create schedule entry.
I am asking 

I am having two date time field

Date time field1 : Assess (July 1, 2023 9 am IST)
Date time field2 : Current date time (july 24 , 2023 12 pm IST)

I want to get duration between these two dates and have to save in another field called Work processed time(duration field).
User datediff I am getting duration but this included weekend and US hoildays. How can I achieve excluding weekend and US hoildays.

[Anil Lande]

Hi,

Have you tried below:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0823046

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0647482