Forum Discussion
Working Hours between two datetimes M-F (Including Saturdays)
I'm trying to figure out to how to implement working hours from two different datetimes. M-F (8A-5P) SATURDAY (8A-4P) Must disregard Holidays I've tried using this method from Bill Szysz but I'...
rogerthat Can you use a DAX solution? Net Work Duration (Working Hours) - Microsoft Power BI Community
Greg_Deckler Would the the solution also account for holidays? So if its a holiday, SLA hours should not be counted?
rogerthat You could have a holidy table and in the __NetWorkDays VAR formula you could do an EXCEPT around the CALENDAR statement to exclude the holidays. Also, in that same statement you would want <7 instead of <6 in order to include Saturdays.
Greg_Deckler I'm not sure the calculation is correct for me
For example, for
start end expected result 9/17/2021 19:58 9/17/2021 21:50 0 112