Calculate the solution time between two log moments based on working hours and business days

[Anonymous]

Hi,

I want to calculate the solution time between two log moments (date_time finished  AND date_time required) based on working hours and business days. By this I mean that weekends, vacations, public holidays and leisure time are excluded from the formula. This will make my results more valid. It needs to be a Power Query formula.

It also needs to be possible to get negative results like this; in hours: -34:13:43 or in seconds: -14543.

An example: 

Friday 25-2-2022 at 16:00 and Monday 28-2-2022 at 11:00. The answer needs to be 4 hours(I prefer the answer to be in seconds, so 14400). Because the workday ends at 17:00 on friday, so from 16 it is 1 hour. And starts again at Monday 8:00, till 11 it is 3 hours. So the result is 4 hours.

Who can help me?

[Greg_Deckler · Accepted solution]

@Anonymous See Working Hours. Net Work Duration (Working Hours) - Microsoft Power BI Community