Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Calculate working hour putting into consideration break time

Topic Labels: Formulas
169 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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