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
