Power Automate flow AddHours to exclude weekends.

(0) Share

Report

Posted on by Caleb62881177

779

Hello everyone,

I want to create a flow that add 12 hours to a time that only includes Business Hours (08:00 - 17:00).

Example:

Monday 08:42 am add 12 hours

Output:

Tuesday 11:42 am

Example:

Friday 08:42 am add 12 hours

Output

Monday 11:42 am

Hopefully someone can help me.

Categories:

Building flows

I have the same question (0)

All responses (40)

Answers (3)

abouchaalaBAIT 932 Moderator on at

Like (0)

Report

Hello,
you can use this technique :
If dayOfWeek(yourDate) equals 1 or 2 or 3 or 4 (Monday to Thursday) => Add 12 hours
If dayOfWeek(yourDate) equals 5 (Friday) => Add 24 + 24 + 24 + 12 in order to skip Saturday and Sunday
If dayOfWeek(yourDate) equals 6 (Staurday) => Add 24 + 24 + 12 in order to skip Sunday
etc ...

----------------------------------------------------------
If I have answered your question, please mark your post as Solved. 🆗✔️
If you like my response, please give it a Thumbs Up. 👍
You can accept more than one post as a solution.

Was this reply helpful? Yes No
Caleb62881177 779 on at

Like (0)

Report

@abouchaalaBAIT I am not sure if your solution factors in not adding hours to the time when it's not in Business hours.

Example:
6pm, 7pm, 8pm etc ...

Was this reply helpful? Yes No
Caleb62881177 779 on at

Like (0)

Report

And I cannot see what you did with the 2 Composes.

Was this reply helpful? Yes No
abouchaalaBAIT 932 Moderator on at

Like (0)

Report

@Caleb62881177 you can add a condition to check if yourtime is between 8AM and 5PM
If for exemple your date = "01/01/2023 06:00 PM" you should check if your date is greater than "01/01/2023 05:00 PM" or less than "01/01/2023 08:00 AM".
Give it a try and let me know

Was this reply helpful? Yes No
Caleb62881177 779 on at

Like (0)

Report

In the flow I have to use addHours() expression to add the 12 hours to the time I use. I still get out of Business Hours results.

Was this reply helpful? Yes No
abouchaalaBAIT 932 Moderator on at

Like (0)

Report
I better understand now.
what you can do is :
get the difference between yourdateTime and Today 5PM (Ex : your DateTime = 01/01/2023 12 PM) => result should be 5
get the difference between 9 hours (Business hours) and the result of previous step (Ex : 9-5 = result2 => 4)
Add 4 hours to next day from 8AM
Next day should be determined depending dayOfWeek(yourDate) (Refer to my first repy and adapt..)
Hope this will help
----------------------------------------------------------
If I have answered your question, please mark your post as Solved. 🆗✔️
If you like my response, please give it a Thumbs Up. 👍
You can accept more than one post as a solution.

Was this reply helpful? Yes No
Caleb62881177 779 on at

Like (0)

Report

Hi @abouchaalaBAIT ,

I was thinking about the calculations for the solution and I figured out that for Monday to Friday you add 16 hours to the time and from Friday to Monday you add 63 hours.

Was this reply helpful? Yes No
abouchaalaBAIT 932 Moderator on at

Like (0)

Report

@Caleb62881177 I don't think so
Let's take your first exemple
Example:
Monday 08:42 am add 12 hours should be => Tuesday 11:42 am
By adding 16 hours the result will be monday night.

Was this reply helpful? Yes No
Caleb62881177 779 on at

Like (0)

Report

@abouchaalaBAIT I meant you first add the 12 hours to 08:42 which makes it 20:42, but if you add 15 hours to it then it becomes 11:42.

Was this reply helpful? Yes No
abouchaalaBAIT 932 Moderator on at

Like (0)

Report

@Caleb62881177 but this will not work for Monday 4:55 pm results should be Wednesday if I understood correctly

Was this reply helpful? Yes No