Need help to calculate time between 2 dates, excluding non-business hours

(0) Share

Report

Posted on by BlindBot

Hi everyone,

I am building a flow that post automated messages everytime a new email arrives.

Every new email is a new job and has a deadline: it is always current time + 5 business hours.

So I used the addHours function, and it works as expected:

addHours(convertTimeZone(utcNow(),'UTC','Romance Standard Time'), 5, 'dddd dd MMM yyyy HH:mm')

The result is something like this: Monday 29 May 2023 23:58

But I have 2 issues:

- our business hours are 9am - 5pm, the addHours function simply adds +5 hours, how can I tell the system to exclude any hour between 5pm and 9am?

- how do I exclude Saturdays and Sundays?

Thank you in advance for any piece of information! 😀

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @BlindBot

Different ways you could do this. Try this.

Expressions I used above are:

addHours(convertTimeZone(utcNow(),'UTC','Romance Standard Time'), 5, 'HH')

addHours(convertTimeZone(utcNow(),'UTC','Romance Standard Time'), 5, 'dddd')

Above expression is as follows:

addHours(convertTimeZone(utcNow(),'UTC','Romance Standard Time'), 5, 'dddd dd MMM yyyy HH:mm')

Was this reply helpful? Yes No
BlindBot 6 on at

Like (1)

Report

Thank you for your help!

The condition function is not ideal, as it's bypassing requests that come late.

Some requests might come on a Sunday, or during the week at midnight.
if so, the deadline should be:
- next business day
- 9am + 5H

I think I need a formula...

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @BlindBot

You could split the condition to check If its Saturday then

addDays(convertTimeZone(utcNow(),'UTC','Romance Standard Time'), 2, 'dddd dd MMM yyyy 09:00')

For Sunday

addDays(convertTimeZone(utcNow(),'UTC','Romance Standard Time'), 1, 'dddd dd MMM yyyy 09:00')

Was this reply helpful? Yes No