SLA calculation

[mohesham]

Hello All

Need a formula to calculate the total duration for a task with the below condition

Business working hours start from 8:00 AM and end 4:00 PM
Task may be assigned to my team at anytime (during or outside the business working hours)
Task may be closed from my team at anytime not just during the working hours
we have no weekends vacations and no public holidays

thanks in advance

 

[Crystalyzer]

your OP is a little vague isn't this just a time diff calculation as below?

Book2
	A	B	C	D
1	Task	Assignment Date	Close Date
2	1	8/20/21 9:00 AM	8/20/21 3:00 PM	6:00
Sheet6

Cell Formulas
Range	Formula
D2	D2	=+C2-B2