Net Work Duration (Working Hours)
Similar to Net Work Days, Net Work Duration calculates the total duration between two date/time columns taking into account non-working days (weekends) as well as the start and end times for a work d...
Greg_Deckler Hi dear friend.
I was reading the whole thread and found it very interesting. I'm just trying to do the calculation.
It would be very useful if the time is outside working hours, the duration time is taken from the next working day starting on working hours (excluding holidays, Saturday noon and Sundays).
example:
Working days: monday to friday working hours 8 am - 5 pm , saturday from 8 am - 1 pm
exclude holidays and sundays
- start date: friday 11 pm
- end date: monday 9 am
- duration: 1 hour
I really appreciate your help
Danilo_Castillo Hey Danilo!! You are in luck my friend, I wrote a Working Hours version of this! Net Work Duration (Working Hours) - Microsoft Power BI Community
Might not be exactly what you need but probably between the two we can get you there! Let me know!