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.
Feb 02, 2022 09:42 AM
Hi everyone!
I’m adding a date field {Fecha de inicio} and a duration field {Tiempo de impresión} to get an end date with hour. But I need to know if the result can skip/exclude non working hours and days so the results are not for example, Sunday at 4 am but Monday at 8am
This is what I have now:
DATEADD({Fecha de inicio},{Tiempo de impresión}, ‘seconds’)
I’d appreciate if someone can help! :slightly_smiling_face:
Feb 07, 2022 07:30 AM
Hi @Tere_Hinojosa,
Welcome back!
You can do the day calculation with the Workday formula, shown below. Incorporating the time into it though would take a bit more. I imagine it would be an IF statement looking at the time, and if its too early, it would be the workday prior and if its too late, it would be the next work day.
WORKDAY(startDate, numDays, [holidays])
Let me know if you have any questions.
Chris