Calculate business hours (not days) between different datetime fields (exclude weekends)

(0) Share

Report

Posted on by irenegr

165

Hello,

I need to have a field (maybe rollup field? ) where it calculates the business hours between timestamps.
For example, I have the start date of a task (10/02/2020 13:16:00) and the end date of the task (10/05/2020 16:50:00)
Working hours are 9.00 - 5.00, so, excluding the weekend and the rest hours of the day, the actually business hours of this task to be completed is 11:34 hours.

Is it possible to calculate this OOB? Do rollup fields support this kind of calculation?
Also, we already have a SLA but it calculates the working hours in a very different way and we don't want to change it.
Thank you in advance

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

RE: Calculate business hours (not days) between different datetime fields (exclude weekends)

Hello,

I don't think it will possible with rollup field. But you can use power automate to achieve your requirement.

Check below article.

ryanmaclean365.com/.../

Please mark my answer verified if i were helpful

Was this reply helpful? Yes No