Help

Calculate working hour putting into consideration break time

Topic Labels: Formulas
533 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Edo_Vigo
5 - Automation Enthusiast
5 - Automation Enthusiast

Maybe the solution is a script, but I’m really after is the time in hours between two dates, but only the business hours.
So Monday - Friday, 8.30am - 12.30pm and 1.30pm - 5.30pm.

just to be clear:
23/6/2022 8:30AM - 23/6/2022 5:30PM. => 8
23/6/2022 8:30AM - 24/6/2022 12:30PM => 12
23/6/2022 8:30AM - 24/6/2022 5:30PM => 16
24/6/2022 8:30AM - 27/6/2022 12:30PM => 12

23/6/2022 8:30AM - 23/6/2022 5:30PM. the result of the formula should be 8
in this case start date and end date have 8 working hours

the second one has this working hour:
23/6/2022 8:30AM - 23/6/2022 12:30AM
23/6/2022 1:30PM - 23/6/2022 5:30PM
24/6/2022 8:30AM - 24/6/2022 12:30PM
in total 12 hours

Do you have a solution for this? Is something like Microsoft project

0 Replies 0