Work Hours calculation

[jawaharprem]

Hi Team,

Please help this formula,

Need to calculate correct work hours by date & time tat is 2 hours from allocation date and closing date
Ex - 11/9/2021 12:34:06 AM - 11/10/2021 7:34:00 AM work hours should by 1 hours bzc after 1AM shift it closed and Saturday & Sunday should not consider
i using this formula but not getting correct hours.

=IF(A11="","",(NETWORKDAYS(A11,D11)-1-MOD(A11,1)+MOD(D11,1))*24)

Allocated	ClaSentD	ClaRecD	Closed	ProcessingTime	WaitingTime	FinalTimeTaken
11/9/2021 10:59	11/9/2021 11:01	11/9/2021 11:10	11/9/2021 13:05	2.11	0.15	1.96
11/9/2021 20:09			11/9/2021 20:44	0.58		0.58
11/9/2021 20:41	11/9/2021 20:50	11/9/2021 20:57	11/9/2021 21:18	0.62	0.12	0.50
11/9/2021 0:34			11/10/2021 7:34	31.00		31.00
11/12/2021 0:47			11/15/2021 7:30	30.72		30.72

Please help on same.

Thanks.

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Work Hours Calculation
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.