Help in calculating Non Business Hours between Two Dates

[pjdsh]

Hello,

I am working on calculating Non Business Hours between two dates excluding Saturday and Sunday and the business hours are from 8 AM to 6 PM. My data looks like this.

TicketNo	TicketCreated Time	Ticket Closed Time
T679768	1/1/2020 5:36	1/2/2020 7:36
T3679769	1/1/2020 5:46	1/3/2020 14:25
T3679770	1/1/2020 9:44	1/2/2020 7:26
T3679818	1/2/2020 10:00	1/6/2020 15:51
T3680027	1/2/2020 18:16	1/6/2020 13:48
T3680034	1/2/2020 21:40	1/7/2020 8:35
T3679807	1/2/2020 9:33	1/2/2020 9:38
T3680823	1/6/2020 16:57	1/8/2020 18:03
T3680920	1/7/2020 9:15	1/14/2020 9:52
T3681281	1/7/2020 21:17	1/8/2020 10:59
T3681293	1/8/2020 5:24	1/8/2020 7:21

Any help in calculating..

[v-jayw-msft · Accepted solution]

Hi @pjdsh ,

Check this PBIX and see if it help.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Gordonlilj]

Hi,

Check out the solutions provided in the posts below and see if they are what you're looking for

Calculate Hours between dates for only business hours 

Calculating Working hours 

[pjdsh]

@Gordonlilj , Thank You.. Will check the posts